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!

Dynamic Sql - insert into x select * from y

jaggyamJan 26 2010 — edited Jan 27 2010

Hello Everyone,

I am trying to write a SP to simulate something similiar to "insert into <source_table> select * from <target_table>" (but record by record) using DBMS_SQL.

Struncture of source and target tables are identical.
Name of the source and target tables will be passed as input to the SP
Need to insert row by row. want to loop thru the source data and insert record by record into target.
no of columns, and column specification would vary based on the source and target table.

Can you guys please help me to complete this...

Thanks inAdvance,
Jaggyam

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2010

Added on Jan 26 2010

9 comments

3,989 views