1.判断表是否存在
select count(*) from user_tables where table_name = 'TABLE_NAME';//(table name 大写),1为存在,0为不存在
2.取出所有的column name
select t.COLUMN_NAME as columnName from User_Tab_Columns t where T.TABLE_NAME = 'TABLE_NAME';//(table name 大写)
3.取出某个column的类型
select DATA_TYPE from User_Tab_Columns t where t.column_name = 'COLUMN_NAME' and T.TABLE_NAME = 'TABLE_NAME';//(table/column name 大写)