摘要:
1.查询表是否存在,如果不存在,就添加select count(*) into v_count from user_all_tables where table_name = 'A'; if v_count = 0 then execute immediate 'create table A(ID NUMBER not null'; end If;2.查询表的主键是否存在,不存在就添加主键select count(*) into v_count from user_cons_columns a where a.constraint_name = 'PK_ 阅读全文
posted @ 2012-09-19 14:06
唐江兰
阅读(1878)
评论(0)
推荐(0)

浙公网安备 33010602011771号