scripting Database

I am using oracle database. From the configuration perspective , I am interested to fetch the stored proc code and table definition from the database. Is there any way to get this ?

To clarify more , I would like to compare the flat sql file with the actual code in database for stored proc and tables. I am badly looking for the answers to this. Thanks in anticipation.

Ajay Kanse

You are trying to access which proc code and table definition from the database. Stored procedures and tables you have to define your self .