Hi team,
So there is this table having 4-5 columns in which we will insert the ID and another column name, (say names) , values , into the child table where the ID there (inside child table) is of number datatype( no primary constraint or FK) and the same column attribute i.e. names, as the former table. The column attribute (names) in the parent table will be having 3-5 values i.e. Sam, Juan, Rajiv, Pedro per row and what we want to insert is that with respect to the ID of parent table we will be inserting each values of that (names column) row wise resulting into duplicate ID values in the child table i.e.
Child table: ID | Attribute
1 Sam
1 Juan
1 Rajiv
1 Pedro
How do we achieve this data migration from the parent table with unique IDs and names column, having one to fewer values in a row, to a child table having duplicate values of ID with each values of names column, being inserted in different rows?
(This is to be done inside Oracle APEX)
Thanks and Regards
Ankan