oracel循环插入数据

来源：互联网发布：oracle linux安装教程编辑：程序博客网时间：2024/04/28 09:43

begin
for i in 1 .. 10000
loop
insert into TFA_ALARM_CLR (FP0, FP1, FP2, FP3, TIME_STAMP, C_FP0, C_FP1, C_FP2, C_FP3, CHANNEL_TYPE, SYN_C_TYPE, INT_ID, OBJECT_CLASS, ALARM_TITLE, ALARM_TITLE_TEXT, EVENT_TIME, ORG_SEVERITY, VENDOR_SEVERITY, ORG_TYPE, VENDOR_TYPE, ACTIVE_STATUS, PROBABLE_CAUSE_TXT, LOCATE_INFO, REDEFINE_SEVERITY, REDEFINE_TYPE, SUB_ALARM_TYPE, ALARM_ORIGIN, RESOURCE_STATUS, ACK_FLAG, VENDOR_ID, VENDOR_NAME, NE_LABEL, NE_LOCATION, REGION_NAME, PROVINCE_ID, PROVINCE_NAME, NETWORK_TYPE, ALARM_RESOURCE_STATUS, PROFESSIONAL_TYPE, SITE_NO, ALARM_TEXT0, ALARM_TEXT1, ALARM_SOURCE, EQP_LABEL, NE_STATUS, NE_ADMIN_STATUS, ALARM_NE_STATUS, LOGIC_ALARM_TYPE, LOGIC_SUB_ALARM_TYPE, STANDARD_ALARM_NAME, STANDARD_ALARM_ID, EFFECT_NE, EFFECT_SERVICE, PROVINCE_PROCESS_FLAG, DEPARTMENT_PROCESS_FLAG, TICKET_CONFIRM_MANNER, SEND_JT_FLAG, INSERT_DB_TIME, EQP_INT_ID, EQP_OBJECT_CLASS, EQP_VERSION, REMOTE_INT_ID, REMOTE_RESOURCE_STATUS, REMOTE_PROJ_SUB_STATUS, ALARM_EQP_STATUS, STANDARD_FLAG, GCSS_CLIENT_LEVEL, GCSS_SERVICE_LEVEL, ALARM_ACT_COUNT, LAYER_RATE, NE_SUB_TYPE, ALARM_ABNORMAL_TYPE, EMS_ID, GCSS_CLIENT_GRADE, GCSS_CLIENT_GRADE_MGT, ALARM_IMPORTANT_LEVEL, PREHANDLE, EQP_OBJECT_CLASS_TEXT, OBJECT_CLASS_TEXT, BOARD_TYPE, NETWORK_TYPE_TOP, IS_SEND_SOUNDBRAND)
values(2142977715 + i, 2639966316, 2202046088, 2216412117, 14512311, 2142977715, 2639966316, 2202046088, 2216412117, 6, 0, 16600757, 2006, 4321, 'IN_PWR_LOW', to_date('2016-06-07 15:00:00','yyyy-mm-dd hh24:mi:ss'), 3, '1', 1, '处理出错告警', 1, 'BER_SD', 'CTT-N-铁通郑州中心程控JJ(TTZZZXCK-TTZZBZ)/DWDM80x10G-1-H-OTM-1-7-10-LBF-01/λ1', 1, 3, 0, 0, 1100, 0, 8, '华为', 'CTT-N-铁通郑州中心程控JJ(TTZZZXCK-TTZZBZ)/DWDM80x10G-1-H-OTM-1-7-10-LBF-01/λ1', 'CTT-N-铁通郑州中心程控JJ(TTZZZXCK-TTZZBZ)/DWDM80x10G-1-H-OTM-1-7-10-LBF-01/λ1', '郑州', -1, '河南', 4001, 1300, 3, '铁通郑州中心程控', 'Location=NA:Direction=NA:MaintenanceStatus=NotInMaintenance:AlarmReason=输入光功率过低_:EquipmentName=LBF:AffirmState=FALSE:DetailInfo=告警参数(16进制) 0x01 0x00 0x01 0xff 0xff:SlaveShelf=Shelf0:DeviceIP=:ROUTE_CAUSE=0:lResSubType=123928576:s', 'lot=190', '集团直采传输', 'CTT-N-铁通郑州中心程控JJ(TTZZZXCK-TTZZBZ)/DWDM80x10G-1-H-OTM', 1100, 1, -1, 35, 131, 'IN_PWR_LOW', '207-061-00-800023', 5, 4, 1, 1, 1, 0, to_date('2016-06-08 15:20:06','yyyy-mm-dd hh24:mi:ss'), 18895158, 2008, 'V1.0', 0, 1100, -1, -1, 2, -1, -1, 0, 73, 21000, 200, 'JT-U2000-37-P', -1, -1, -1, 0, '42008', '42006', 1, 4, -1);

end loop;
commit;
end;

0 0