Shell Programming and Scripting

Hi,

I need a sample script to validate all the database objects like

1. table structure(columns, datatypes,key contraints if any)
2. synonyms
3. grants
4. indexes
....etc

thank you!

And ?

1. table name and schema name should be passed as input parameters to the script
2. taking those inputs it should validate all the database objects
3. after validating it should write to a .csv or excel file
writing output should be like this
SELECT table_name, column_name, data_type, data_length, nullable
FROM all_tab_columns
WHERE table_name IN ('$TABLE_NAME') AND owner IN ('$OWNER_NAME')
ORDER BY column_id;