Oracle列出数据库所有表名和列名

Oracle列出数据库所有表名和列名

1 Oracle显示所有表名:
 select table_name from user_tables;
 
2 Oracle显示所有列名:
 select OWNER, TABLE_NAME, COLUMN_NAME
 from all_tab_columns
 where table_name = atablename;
 
附:
Oracle创建临时表
 
CREATE GLOBAL TEMPORARY TABLE Table_name
    (startdate DATE,
      enddate DATE,
      class CHAR(20))
  ON COMMIT DELETE ROWS;