随笔分类 -  oracle

摘要：1.SELECT tname from tab where tname ='HB_PROJECT_TEMPORARY_DATA' --查询表是否存在2.create table hb_project_temporary_data as select * from hb_project_data where 1=2 --复制表结构并创建3."select * from User_Tab_Columns where table_name='tablename' and column_name='column'" --表名和列名都必 阅读全文