Any advise please...
Printable View
Any advise please...
Is that you want?PHP Code:
SQL> desc t1
Name Null? Type
------------------------ -------- ----------------------------
ID NUMBER(38)
NAME VARCHAR2(30)
SQL> desc t2
Name Null? Type
------------------------ -------- ----------------------------
ID NUMBER(38)
NAME VARCHAR2(30)
SQL> select * from t1;
ID NAME
---------- ------------------------------
1 aaaaaaa
2 bbb
3 ccccccccc
4 dddddddd
5 eeeeeee
SQL> select * from t2 ;
ID NAME
---------- ------------------------------
1 aaaaaaa
3 ccccccccc
5 eeeeeee
SQL> get ins
1 declare
2 L_id number ;
3 cursor c1 is
4 select id , name from t1;
5 begin
6 for c1rec in c1 loop
7 begin
8 select id into L_id from t2 where id = c1rec.id;
9 exception when no_data_found then
10 insert into t2 values (c1rec.id, c1rec.name) ;
11 end;
12 end loop;
13 commit;
14 exception when others then raise ;
15* end;
16 /
PL/SQL procedure successfully completed.
SQL> select * from t2;
ID NAME
---------- ------------------------------
1 aaaaaaa
3 ccccccccc
5 eeeeeee
2 bbb
4 dddddddd
SQL> spool off
Tamil
You are the man :)Quote:
Originally posted by tamilselvan
Thanks a lot!