Title: RE: need help with dynamic sql
if you at-least know the source and destination tables will have same number of columns and data types ... you could just do something like
insert into target.table
select from source.table
Raj
Not with execute immediate. Use dbms_sql
I have done this.
For example and help
http://asktom.oracle.com/pls/ask/f?p=4950:8:104566430235951855::NO::F495
0_P8_DISPLAYID,F4950_P8_CRITERIA:584023239495,
Regards,
Kamaljeet Singh (NCDB ASG)
MBT, 52 Barrack Square, Martlesham. IP5 3RF.
Off. 01473
the comma delimited string of columns.
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/03/11 Tue AM 11:29:03 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: need help with dynamic sql
if you at-least know the source and destination tables will have same number