常用SQL

 

找查有用的表：

 

select c.TABLE_NAME,c.COLUMN_NAME,c.DATA_TYPE||'('||c.DATA_LENGTH||')',c.NULLABLE,c.DATA_DEFAULT
  from cols c
 where c.TABLE_NAME in
       (select t.table_name from user_tables t where t.num_rows > 0) order by c.TABLE_NAME,c.COLUMN_ID;