马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册 
 
 
 
×
 
我不知道要怎么对数据进行些修改然后再在sybase执行导入,比如我给个例子,请大家帮我看看要怎么修改后才能在sybase里执行 
prompt PL/SQL Developer import file 
prompt Created on 2009年5月21日 星期四 by Administrator 
set feedback off 
set define off 
prompt Disabling triggers for CFG_ALARMTYPE... 
alter table CFG_ALARMTYPE disable all triggers; 
prompt Deleting CFG_ALARMTYPE... 
delete from CFG_ALARMTYPE; 
prompt Loading CFG_ALARMTYPE... 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (50, '硬件接口板卡类告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (53, '硬件射频类告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (54, '硬件其它类', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (55, '系统内部通信告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (56, '性能告警无线-系统软件告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (57, '硬件内部交换类告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (58, '硬件时钟类告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (3, '环境告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (1, '通信告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (4, '设备告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (2, '服务质量告警', '3', 1); 
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT) 
values (13, '其他类告警', '3', 1); 
prompt 12 records loaded 
prompt Enabling triggers for CFG_ALARMTYPE... 
alter table CFG_ALARMTYPE enable all triggers; 
set feedback on 
set define on 
prompt Done. |