SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert multiple rows on table based on other table's column value

user8629294Jan 25 2021

HI,
I am using oracle 11g release 11.2.0.4.0. I have a problem regarding inserting multiple rows into table based on other table's column value .Let me explain me bit more .
I have a table PATIENT and other table CROSS_REF AS mentioned below .
How to build insert statement from patient and cross ref so that i will get the desired output. I tried with merge but i could not accomplish.

This post has been answered by Frank Kulash on Jan 25 2021

Jump to Answer

Added on Jan 25 2021

#sql

6 comments

2,853 views

1 mention