[ Programming ] [ Learn Oracle ] [ Learn VB ] [ Learn Java ] [ Learn SE ]

Search this site(enter key word):  

Helping the mankind

Hot Oracle Links

The best RDBMS

Database programmers always need to query the system tables even for finding out the primary key.  To overcome the problems they face, I have written a package to help the developers to query on system tables, which otherwise difficult to remember the system tables and their relationships.  Download the Utility and add and/or modify new functionalities to suit your needs. 

Example 1:

1. set serveroutput on
2. -- replace the TABLE_NAME with any existing table.
3. -- TABLE_NAME should be in upper case.
4. exec pk_utility.Desc( 'TABLE_NAME'  ) 

Displays the complete description of your 'TABLE_NAME' which also include primary key, foreign key.

Remember this utility is not documented fully, so you have to wade through the code to understand the program. Though I am using this utility successfully in my work, I am not responsible for any damage caused at your place because of this program.

NOTE:  If you have Toad installed in your PC, then you do not require this utility.

[ Home ] [ Up ] [ Hot Oracle Links ]

Send mail to arungomes@eircom.net with questions or comments about this web site.
Copyright © 1999 Empire Cyber IT Consultancy
Last modified: January 06, 2000