Oracle lists all table names and column names

Oracle lists all the table names. The column name takes one day. there may be better methods. test environment: oracle xe 11g 1 shows all table names: select table_name from user_tables; 2 shows all column names: select OWNER, TABLE_NAME, COLUMN_NAMEfrom all_tab_columns where table_name = atablename; Appendix: -- Example: create temporary table. http://stackoverflow.com/questions/2671518/how-to-create-a-temporary-table-in-oracleCREATE global temporary table Table_name (startdate DATE, enddate DATE, class CHAR (20) on commit delete rows;