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