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