Oracle列出資料庫所有表名和列名

1 顯示所有表名:

select table_name from user_tables;

2 顯示所有列名:

select OWNER, TABLE_NAME, COLUMN_NAME

from all_tab_columns 

where table_name = atablename;

附:

建立臨時表

CREATE GLOBAL TEMPORARY TABLE Table_name

    (startdate DATE,

     enddate DATE,

     class CHAR(20))

  ON COMMIT DELETE ROWS;