Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

To insert values from one table to another

edited Apr 16, 2022 7:50AM in Autonomous Database 2 comments

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!