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;