Simple Schema

[IanWaterman]

I am a beginner SQL programmer.

I am working with an Oracle 8 database which has no schema information.

If I use

desc Tablename

I get the info I need about that table, is there as similar command where I can list and describe all tables. I can then export this to Excel and get a better understanding about tables and realtionships etc.

Thanks in advance

Ian

 

[rrrkrishnan]

try this.

select 'desc'||table_name||';' from all_tables where owner=whatever database you are interested in.
Redirect this output to a file and run the file as you would do a sqlplus script.