prompt PL/SQL Developer import file prompt Created on 2026年7月22日 by 花宝男朋友 set feedback off set define off prompt Creating METER_WORK_MONITOR... create table METER_WORK_MONITOR ( point_no VARCHAR2(20) not null, point_name VARCHAR2(40), valid_wgt VARCHAR2(1) default 1, valid_carno VARCHAR2(1) default 1, valid_tare_time VARCHAR2(1) default 1, valid_time_interval VARCHAR2(1) default 1, valid_park_status VARCHAR2(1) default 1, valid_exceed_wgt VARCHAR2(1) default 1, valid_prediction_diff VARCHAR2(1) default 1, valid_flag VARCHAR2(1) default 1, valid_mat_time VARCHAR2(1) default 1, car_monitor VARCHAR2(1) default 0, car_monitor_lvl NUMBER default 0, is_help VARCHAR2(1) default 0, is_take_over VARCHAR2(1) default 0, led_writer VARCHAR2(200), print_num NUMBER(4) default 0, collection_code VARCHAR2(20), is_over_wgt VARCHAR2(40) default 0, user_no VARCHAR2(20), monitor_user_no VARCHAR2(20), set_car VARCHAR2(20), led_keep VARCHAR2(1) default 0, rfid_car VARCHAR2(20), photo_car VARCHAR2(20), scan_car VARCHAR2(20), edit_car VARCHAR2(20), car_err VARCHAR2(1) default 0, wgt_err VARCHAR2(1) default 0, last_time DATE, stop_over_time VARCHAR2(1), msg_info VARCHAR2(400), wgt NUMBER(10) default 0, is_remote VARCHAR2(1), weigh_instrument_model VARCHAR2(60), weigh_instrument_param VARCHAR2(100), moxa_ip VARCHAR2(20), moxa_port VARCHAR2(10), valid_lianda VARCHAR2(1) default 1, is_open_scanning VARCHAR2(1) default 0, valid_is_pre VARCHAR2(1) default 0, user_ip VARCHAR2(30), power_state VARCHAR2(1) default 0, dvr_state VARCHAR2(1) default 0, moxa_state VARCHAR2(1) default 0, plc_state VARCHAR2(1) default 0, left_infrared_ray_state VARCHAR2(1) default 0, right_infrared_ray_state VARCHAR2(1) default 0, amplifier_state VARCHAR2(1) default 0, lamp_state VARCHAR2(1) default 0, spot_type_no VARCHAR2(20) default 0, red_green_light_state VARCHAR2(1) default 0, front_infrared_ray_state VARCHAR2(1) default 0, rear_infrared_ray_state VARCHAR2(1) default 0, rfid_state VARCHAR2(1) default 0, valid_area VARCHAR2(1) default 1, weight_status VARCHAR2(2) default 0, ferroalloy_confirm VARCHAR2(1) default 0, ferroalloy_result VARCHAR2(200), zero_state VARCHAR2(1) default 0, zero_weight NUMBER, is_zero_state VARCHAR2(1) default 1, is_valid_scan VARCHAR2(1) default 1, is_enable_sound VARCHAR2(1) default 1, photo_car2 VARCHAR2(20) ) ; comment on table METER_WORK_MONITOR is '计量监控表'; comment on column METER_WORK_MONITOR.point_no is '计量点编号'; comment on column METER_WORK_MONITOR.point_name is '计量点'; comment on column METER_WORK_MONITOR.valid_wgt is '验证重量 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_carno is '验证车号 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_tare_time is '验证回皮时间 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_time_interval is '验证时间间隔 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_park_status is '验证对射(实时数据库停车位置) 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_exceed_wgt is '验证危化品超重 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_prediction_diff is '验证毛皮超差 0不验证 1验证'; comment on column METER_WORK_MONITOR.valid_flag is '是否有效 1有效 0无效'; comment on column METER_WORK_MONITOR.valid_mat_time is '验证物料可计量时间段 0不验证 1验证'; comment on column METER_WORK_MONITOR.car_monitor is '是否进行车号修正 0不修正 1修正'; comment on column METER_WORK_MONITOR.car_monitor_lvl is '车号修正级别1-3（1=修正1位；2=修正连续的2位；3=修正连续的3位）'; comment on column METER_WORK_MONITOR.is_help is '0未呼叫，1呼叫待接听，2呼叫已接听'; comment on column METER_WORK_MONITOR.is_take_over is '0智能终端，1远程计量呼叫(派位阶段)，2远程接管'; comment on column METER_WORK_MONITOR.led_writer is '写入LED的值'; comment on column METER_WORK_MONITOR.print_num is '打印纸张'; comment on column METER_WORK_MONITOR.collection_code is '与实时库对应的采集点'; comment on column METER_WORK_MONITOR.is_over_wgt is '有值时为计量完成'; comment on column METER_WORK_MONITOR.user_no is '接管终端用户'; comment on column METER_WORK_MONITOR.monitor_user_no is '监控用户'; comment on column METER_WORK_MONITOR.set_car is '重置车号'; comment on column METER_WORK_MONITOR.led_keep is '0不读取LED_WRITER的值，1读取'; comment on column METER_WORK_MONITOR.rfid_car is 'rfid车号'; comment on column METER_WORK_MONITOR.photo_car is '抓拍车号'; comment on column METER_WORK_MONITOR.scan_car is '扫描车号'; comment on column METER_WORK_MONITOR.edit_car is '修正车号'; comment on column METER_WORK_MONITOR.car_err is '车号异常 0正常 1异常'; comment on column METER_WORK_MONITOR.wgt_err is '重量异常 0正常 1异常'; comment on column METER_WORK_MONITOR.last_time is '最后在线时间，由于时间不一定准，所以使用旧数据时间与当前时间比如果连续30次相同则认为掉线'; comment on column METER_WORK_MONITOR.stop_over_time is '0正常 1停留超时'; comment on column METER_WORK_MONITOR.msg_info is '现场终端提示信息'; comment on column METER_WORK_MONITOR.wgt is '现场显示的重量'; comment on column METER_WORK_MONITOR.is_remote is '是否是监控界面点击的远程 0否 1是'; comment on column METER_WORK_MONITOR.weigh_instrument_model is '称重仪表型号'; comment on column METER_WORK_MONITOR.weigh_instrument_param is '称重仪表参数'; comment on column METER_WORK_MONITOR.moxa_ip is 'MOXA卡IP'; comment on column METER_WORK_MONITOR.moxa_port is 'MOXA卡端口'; comment on column METER_WORK_MONITOR.valid_lianda is '验证联达 0不验证 1验证'; comment on column METER_WORK_MONITOR.is_open_scanning is '现场扫码器是否正常连接(0=连接异常，1=连接正常)'; comment on column METER_WORK_MONITOR.valid_is_pre is '委托异常 0正常 1异常'; comment on column METER_WORK_MONITOR.user_ip is '接管用户IP'; comment on column METER_WORK_MONITOR.power_state is '衡器电源状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.dvr_state is '硬盘录像机状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.moxa_state is 'MOXA状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.plc_state is 'PLC状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.left_infrared_ray_state is '红外对射状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.right_infrared_ray_state is '红外对射状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.amplifier_state is '功放状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.lamp_state is '照明灯状态（0关闭的 1打开的）'; comment on column METER_WORK_MONITOR.spot_type_no is '站点类型'; comment on column METER_WORK_MONITOR.red_green_light_state is '红绿灯状态（0绿灯 1红灯）'; comment on column METER_WORK_MONITOR.front_infrared_ray_state is '前红外光栅状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.rear_infrared_ray_state is '后红外光栅状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.rfid_state is 'rfid状态（0正常 1异常）'; comment on column METER_WORK_MONITOR.valid_area is '允许异地结净 0不验证 1验证'; comment on column METER_WORK_MONITOR.weight_status is '重量是否稳定 0不稳定 1稳定'; comment on column METER_WORK_MONITOR.ferroalloy_confirm is '铁合金确认 0未确认 1已确认'; comment on column METER_WORK_MONITOR.ferroalloy_result is '铁合金确认结果 0保存失败 1保存成功'; comment on column METER_WORK_MONITOR.zero_state is '零点报警 0不报警 1报警'; comment on column METER_WORK_MONITOR.zero_weight is '零点重量'; comment on column METER_WORK_MONITOR.is_zero_state is '验证零点报警 0:不验证 1:验证'; comment on column METER_WORK_MONITOR.is_valid_scan is '允许扫码计量（0：允许；1：不允许，数据库默认为1）'; comment on column METER_WORK_MONITOR.is_enable_sound is '是否播放声音（0：不播放；1：播放）'; comment on column METER_WORK_MONITOR.photo_car2 is '抓拍车号2'; alter table METER_WORK_MONITOR add constraint MONITOR_PK primary key (POINT_NO); prompt Disabling triggers for METER_WORK_MONITOR... alter table METER_WORK_MONITOR disable all triggers; prompt Loading METER_WORK_MONITOR... insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0038', '吉瑞渣厂150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR18', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:08', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT1111', '实训室', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR50', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('06-08-2025 13:26:36', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.99', '0', '1', '1', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0128', '东铝二期氧化铝库1号汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR23', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:06', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.107', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0129', '东铝二期氧化铝库2号汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR24', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:04', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.99', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0104', '东铝二期120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR12', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:12', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.101', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JTS0001', '镜铁山150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR68', null, null, null, null, '0', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:14', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.102.0.166', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0041', '东铝一期120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR15', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:07', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0001', '1#公路汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR01', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:07', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0006', '8#门汽车衡西秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR05', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0005', '8#门汽车衡东秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR06', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0007', '9#门汽车衡东秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR03', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:06', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0008', '9#门汽车衡西秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR04', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('20-07-2026 15:47:04', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0010', '不锈钢汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR17', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:08', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0032', '汇丰不锈钢工业园150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR21', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 18:28:25', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.3.78', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0138', '物流园汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR69', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('19-06-2026 02:02:35', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 75, null, null, null, null, null, '1', '0', '0', '10.130.0.103', '0', '0', '0', '0', '0', '0', '0', '1', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '1', 72, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0136', '润源兴源门150t汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR71', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:13', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.100.248.87', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0137', '润源兴源门150t汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR77', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:13', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0135', '润源废钢100t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR73', null, null, null, null, '0', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:12', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0139', '储运新一料场汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR70', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.100.248.87', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0020', '1#公路汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR02', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0034', '5#门汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR08', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('10-07-2026 09:43:54', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.101', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0035', '5#门汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR09', null, null, null, null, '1', null, '甘B02800F', null, null, '0', '0', to_date('22-07-2026 19:03:59', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 79800, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('LX0001', '陇西50t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR60', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:10', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 30780, null, null, null, null, null, '1', '0', '0', '10.130.2.229', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', '甘JGL005'); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('LX0002', '陇西100t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR61', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('03-06-2026 07:48:03', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.2.247', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('LX0003', '陇西120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR62', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:03', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.2.145', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '1', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JTS0002', '铜选厂120t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR67', null, null, '0015780', null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:12', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.230.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '0', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0047', '嘉北4#门汽车衡东秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR10', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:10', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0052', '吉瑞200t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR19', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:04', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0023', '废钢汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR16', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 11:00:18', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.133.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0026', '铁合金汽车衡北秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', '走', 0, 'CAR14', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('28-06-2026 09:05:51', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0027', '铁合金汽车衡南秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR13', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:10', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.104', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0031', '200万料场汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '1', null, 0, 'CAR07', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('25-06-2026 10:33:57', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.105', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0060', '葫芦山汽车衡', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', 0, '0', '0', null, 0, 'CAR06', '20220825174721437924', null, 'test01', null, '0', null, null, null, null, '0', '0', to_date('21-07-2022 09:17:45', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.130.0.97', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', null, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0048', '嘉北4#门汽车衡西秤', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR11', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:06', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '192.168.129.1', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); insert into METER_WORK_MONITOR (point_no, point_name, valid_wgt, valid_carno, valid_tare_time, valid_time_interval, valid_park_status, valid_exceed_wgt, valid_prediction_diff, valid_flag, valid_mat_time, car_monitor, car_monitor_lvl, is_help, is_take_over, led_writer, print_num, collection_code, is_over_wgt, user_no, monitor_user_no, set_car, led_keep, rfid_car, photo_car, scan_car, edit_car, car_err, wgt_err, last_time, stop_over_time, msg_info, wgt, is_remote, weigh_instrument_model, weigh_instrument_param, moxa_ip, moxa_port, valid_lianda, is_open_scanning, valid_is_pre, user_ip, power_state, dvr_state, moxa_state, plc_state, left_infrared_ray_state, right_infrared_ray_state, amplifier_state, lamp_state, spot_type_no, red_green_light_state, front_infrared_ray_state, rear_infrared_ray_state, rfid_state, valid_area, weight_status, ferroalloy_confirm, ferroalloy_result, zero_state, zero_weight, is_zero_state, is_valid_scan, is_enable_sound, photo_car2) values ('JT0127', '汇丰公司150t汽车衡', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 0, '0', '0', null, 0, 'CAR22', null, null, null, null, '1', null, null, null, null, '0', '0', to_date('22-07-2026 19:04:09', 'dd-mm-yyyy hh24:mi:ss'), '0', null, 0, null, null, null, null, null, '1', '0', '0', '10.100.248.87', '0', '0', '0', '0', '0', '0', '0', '0', '001002001', '0', '0', '0', '2', '1', '0', '0', '0', '0', 0, '1', '1', '1', null); commit; prompt 35 records loaded prompt Enabling triggers for METER_WORK_MONITOR... alter table METER_WORK_MONITOR enable all triggers; set feedback on set define on prompt Done.