firemail

标题: 批量连续处理脚本 [打印本页]

作者: jeesite 时间: 2016-12-10 21:05
标题: 批量连续处理脚本
declare
  cusObjCount number;
begin
dbms_output.put_line('试验单位申请表');
select count(1) into cusObjCount from user_tables where table_name='SYDW_SQB';
if cusObjCount > 0 then
   execute immediate 'drop table SYDW_SQB';
end if;
execute immediate 'CREATE TABLE SYDW_SQB
(
   id varchar2(64) NOT NULL,
   frdm nvarchar2(200),
   is_dlfrjg nvarchar2(64), /* 依赖字典表 type = ''yes_no''*/
   create_by varchar2(64),
   create_date timestamp,
   update_by varchar2(64),
   update_date timestamp,
   remarks nvarchar2(255),
   del_flag char(1) DEFAULT ''0'' NOT NULL,
   PRIMARY KEY (id)
)';
/* Comments */
execute immediate 'COMMENT ON TABLE sydw_sqb IS ''试验单位_申请表''';

execute immediate 'COMMENT ON COLUMN sydw_sqb.id IS ''编号''';

作者: jeesite 时间: 2016-12-11 11:53
pl/sql .sql脚本遇到错误后，不会再向下执行

欢迎光临 firemail (http://firemail.wang:8088/)