Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query to view sql logic behind a table

62b24261-14c2-4de6-b8f0-1c6ebef0cc1aApr 27 2017 — edited Apr 28 2017

Hi,

In PL/SQL,when we right click on a table name and select view option from the list, the code related to the tbale will be viewed (for example the code that creates the indexes for the table).

All this we do manually by selcting the options that isĀ  a part of GUI. Is there any way so that all this GUI process can be done with one query(without right clicks and all and directly retieving the logic that creates indexes for the table).Simply a programming query that does the work of human interventiuon with GUI.

Please help me with this.

Thanks,

Vasundhara

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2017
Added on Apr 27 2017
11 comments
5,229 views