Information on System Tables
Posted on 2003-03-05
I want the information on system tables of oracle and other information on oracle tables.
Actually I want to know where the oracle procedures and other PL/SQL blocks, triggers are stored. I had created a trigger in oracle which is written in a file with new.sql. The trigger was created succesfully. After that I deleted the file new.sql. now I want the code that i had wirtten in that trigger.how I can get that information. i.e., In which user/system table the trigger and procedures information will be stored.
I waiting for your reply.