| Conditional INSERT [message #627304] |
Mon, 10 November 2014 14:51  |
shree_z
Messages: 75
Registered: February 2008
|
Member |
|
|
In table t1, how can I insert only those rows that doesnt exist already. If a row exists, I want to skip inserting that row.
for rec in (select column1, column2....columnn,
from table1,table 2, table3, table4
where conditions)
loop
begin
insert into t1
values (rec.column1, rec.column2 ..)
end;
end loop;
Thanks in advance.
[Updated on: Mon, 10 November 2014 14:52] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Conditional INSERT [message #627417 is a reply to message #627400] |
Tue, 11 November 2014 14:07  |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
You never needed a cursor. simply do
insert into t1
select column1, column2....columnn,
from table1,table 2, table3, table4
where conditions
and not exists
(select null
from t1 a
where a.key_column_for_t1 = table1.col1
and conditions);
[Updated on: Tue, 11 November 2014 14:08] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
