list a tables columns.sql

on June 23, 2008 at 12:26 pm
Posted In: Oracle DB Objects (tables, sql etc) (Cat)

— col_lst.sql
set pause off
col owner form a10
col table_name form a20 word wrap
col column_name form a20 word wrap
spool col_lst.lst
select owner,table_name,column_name
from dba_tab_columns
where column_name like (nvl(upper(‘&col_nam’),’WHOOPS’)||’%’)
ORDER BY TABLE_NAME,OWNER
/
clear colu
SPOOL OFF