摘要：insert into tableName (x1,x2,x3,x4,x5,x6) select x1, x2, x3, x4, ' 你好', sysdate from tableName1 t where t.x1= 'x1_ss' 阅读全文

摘要：select COLUMN_NAMEfrom user_tab_columnswhere Table_Name = 'TABLE_NAME'order by column_name; 注表名需大写； 阅读全文