| Re: describe- spool commands to file [message #369557] |
Fri, 20 October 2000 15:10 |
Andrew
Messages: 144
Registered: March 1999
|
Senior Member |
|
|
SQL> set echo on
SQL> set pagesize 0
SQL> column Table_Descr format a56 wrap
SQL> select '/* '||rpad('Table: '||owner||'.'||table_name, 50, ' ')||' */'||
2 ' descr '|| owner||'.'||table_name||';' Table_Descr
3 from all_tables where owner = 'ABC'
4 /
/* Table: ABC.DCCESS_TECHNOLOGY */
descr ABC.DCCESS_TECHNOLOGY;
/* Table: ABC.DCCESS_TYPE */
descr ABC.DCCESS_TYPE;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
