- select TABLE_NAME from dba_tables where owner='test' order by table_name ASC
- SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM USER_TAB_COLUMNS
- WHERE TABLE_NAME NOT IN (SELECT VIEW_NAME FROM USER_VIEWS ) and table_name='testtb' ORDER BY COLUMN_ID ASC
- SELECT * FROM TAB