Re: INSERT with WHERE???

ASK wrote:
> Hi,
>
> Could you illustrate the below by some example?
> INSERT
> WHEN (<condition>) THEN
> INTO <table_name> (<column_list>)
> VALUES (<values_list>);

I read it here:
http://www.psoug.org/reference/insert.html

create table inswhen(a number, b number);

insert into inswhen values (1, 2);
insert into inswhen values (2, 3);

insert
when (a + b = 3) then

   into inswhen values (6, 7)
else

   into inswhen values (a, b)
select 1 a, 1 b from dual where 1=0;

The OP would better go with merge

merge into inswhen
  using dual
on <condition>
when not matched then
insert; Received on Tue Dec 12 2006 - 11:20:35 CST