Hi!
I have here data:
i don't have any idea on how to insert the details in TABLE2...
as you can see, the parent_id is based on TABLE1,
TABLE 1 TABLE 2 (INSERTED IN NEW TABLE)
LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1)
1 NODEB EQUIPMENT 1 NODEB
2 NODEB_RADIO_MODULE NODEB 2 NODEB_RADIO_MODULE 2 1
2 NODEB_SYSTEM_MODULE NODEB 3 NODEB_SYSTEM_MODULE 3 1
2 NODEB_RADIO_MODULE NODEB 4 NODEB_RADIO_MODULE 4 1
3 NODEB_IF_CARD NODEB_SYSTEM_MODULE 5 NODEB_IF_CARD 5 3
3 CLOCK_PORT NODEB_SYSTEM_MODULE 6 CLOCK_PORT 6 3
3 ETHERNET_PORT NODEB_SYSTEM_MODULE 7 ETHERNET_PORT 7 3
3 ETHERNET_PORT NODEB_SYSTEM_MODULE 8 ETHERNET_PORT 8 3
3 ETHERNET_PORT NODEB_SYSTEM_MODULE 9 ETHERNET_PORT 9 3
3 ETHERNET_PORT NODEB_SYSTEM_MODULE 10 ETHERNET_PORT 10 3
4 NODEB_SYS_PORT NODEB_IF_CARD 11 NODEB_SYS_PORT 11 5
4 NODEB_SYS_PORT NODEB_IF_CARD 12 NODEB_SYS_PORT 12 5
4 E1_PORT NODEB_IF_CARD 13 E1_PORT 13 5
4 E1_PORT NODEB_IF_CARD 14 E1_PORT 14 5
4 E1_PORT NODEB_IF_CARD 15 E1_PORT 15 5
4 E1_PORT NODEB_IF_CARD 16 E1_PORT 16 5
4 E1_PORT NODEB_IF_CARD 17 E1_PORT 17 5
4 E1_PORT NODEB_IF_CARD 18 E1_PORT 18 5
4 E1_PORT NODEB_IF_CARD 19 E1_PORT 19 5
4 E1_PORT NODEB_IF_CARD 20 E1_PORT 20 5