Page Comparison

...

1. Find the next instance for dictionary_id:

      SELECT * FROM NEXT_INSTANCE WHERE TABLE_NAME LIKE 'RULESDBO.DICTIONARIES

2. Insert into the dictionary_table using dictionary_id from the last query + 1:
   insert into rulesdbo.dictionaries ( Dictionary_ID, Dictionary_name, Dictionary_type, UPDATE_DATE )values ( 4, 'Mutual Fund Perf Model', 'P', SYSDATE)INSERT INTO RULESDBO.DICTIONARY_FORMAT
   ( Dictionary_ID, Dictionary_Level, Field_attribute_ID, Dictionary_Level_Desc)VALUES(4, 1, -1, 'TOTAL')

3. Find the next instance for dictionary_detail_id:
   SELECT * FROM NEXT_INSTANCE WHERE TABLE_NAME = 'RULESDBO.DICTIONARY_DETAIL' ;

4. Add 1 to the result and insert into dictionary_detail:INSERT INTO RULESDBO.DICTIONARY_DETAIL(Dictionary_ID, Dictionary_Detail_id, Dict_L1_Code_value, Dict_L2_Code_value, Dict_L3_Code_value, dictionary_item_id , SOURCE_CODE_ID) VALUES (4, 2, 'TOTAL', NULL, NULL, 1, 10 )

5. Update the NEXT_INSTANCE table:

   UPDATE NEXT_INSTANCE
   SET NEXT_INST = ( NEXT_INST + 1)WHERE TABLE_NAME IN( 'RULESDBO.DICTIONARIES', 'RULESDBO.DICTIONARY_DETAIL' ) ;