[thesite] rudy, i dropped a couple tables

Dean Mah dsmah at home.com
Wed May 23 13:15:55 CDT 2001


I put a script called listcat on the oracle box.  It's in the dmah
directory.  After you've logged in as the oracle user, you can do:

   @dmah/listcat

It will prompt you for a table name and it should give you a lot more
information than 'desc' does.  Make sure that you window width is
fairly large as it formats for greater than 80 columns.

Dean


rudy writes:

> foreign keys and stuff are a lot harder to pull from oracle's system
> tables, and i don't have any working scripts for those kinds of
> things yet
>
> if anybody has any useful ones, please let us know




More information about the thesite mailing list