Edit D:\app\Administrator\product\11.2.0\dbhome_1\jlib\oracle\sysman\vdm\VdmDBConstants.class
?? / K 3 4 s_sNotificationTable Ljava/lang/String; ConstantValue 5 s_sAddressTable 6 s_sGlobalInfoTable 7 s_sNotificationDetailsTable 8 s_sNotificationSequenceNum 9 s_sInsertNotfnStmt : s_sInsertNotfnStmt2 ; s_sInsertAddrStmt < s_sSelectSeqnum = s_sUpdateCounter > s_sSelectNotification ? s_sSelectAddress @ s_sSelectForUpdate A s_sDeleteNotification B s_sInsertGlobalInfo C s_sSelectGobalInfo D s_sSelectGobalInfoForUpdate E s_sUpdateGlobalInfo F s_sDeleteGlobalInfo G s_sInsertNotfnDetailsStmt H s_sSelectNotfnDetailsStmt I s_sDeleteNotfnDetailsStmt J SourceFile VdmDBConstants.java oracle/sysman/vdm/VdmDBConstants java/lang/Object SMP_VDM_NOTIFICATION SMP_VDM_ADDRESS SMP_VDM_GLOBAL_INFO SMP_VDM_NOTIFICATION_DETAILS SMP_VDM_SEQUENCE_NUM ?NSERT INTO SMP_VDM_NOTIFICATION (sequence_num, notification_id, notification_type, subtype, node_name, service_name, service_type, time_stamp, time_zone, verbose, domain, num_clients) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO SMP_VDM_NOTIFICATION (sequence_num, notification_id, notification_type, subtype, node_name, service_name, service_type, time_stamp, time_zone, verbose, domain, num_clients) VALUES ( %s, %s, %s, %s, '%s', '%s', '%s', %s, %s, %s, '%s', %s) lINSERT INTO SMP_VDM_ADDRESS (sequence_num, username, app_name, enhanced_notification ) VALUES ( ?, ?, ?, ?) 2SELECT SMP_VDM_SEQUENCE_NUM.NEXTVAL FROM SYS.DUAL H UPDATE SMP_VDM_NOTIFICATION SET num_clients = ? WHERE sequence_num = ? ?ELECT sequence_num, notification_id, notification_type, subtype, node_name, service_name, service_type, time_stamp, time_zone, verbose, domain FROM SMP_VDM_NOTIFICATION WHERE sequence_num = ? ^SELECT username, app_name, enhanced_notification FROM SMP_VDM_ADDRESS WHERE sequence_num = ? `SELECT notification_id, num_clients FROM SMP_VDM_NOTIFICATION WHERE sequence_num = ? FOR UPDATE 2DELETE SMP_VDM_NOTIFICATION WHERE sequence_num = ? rINSERT INTO SMP_VDM_GLOBAL_INFO (service_type, service_name, property_name, property_value ) VALUES ( ?, ?, ?, ?) rSELECT property_value FROM SMP_VDM_GLOBAL_INFO WHERE service_type = ? AND service_name = ? AND property_name = ? }SELECT property_value FROM SMP_VDM_GLOBAL_INFO WHERE service_type = ? AND service_name = ? AND property_name = ? FOR UPDATE tUPDATE SMP_VDM_GLOBAL_INFO SET property_value = ? WHERE service_type = ? AND service_name = ? AND property_name = ? dDELETE FROM SMP_VDM_GLOBAL_INFO WHERE service_type = ? AND service_name = ? AND property_name = ? ?NSERT INTO SMP_VDM_NOTIFICATION_DETAILS (name, type, target, execNum, owner, time_stamp, time_zone, method, status, message) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) nSELECT ****** owner, time_stamp, method, status, time_zone, message FROM SMP_VDM_NOTIFICATION_DETAILS WHERE %s 2DELETE FROM SMP_VDM_NOTIFICATION_DETAILS WHERE %s ! "