insert and not exists

[Mnemonical]

The query works, but returns nothing, then no rows are created.


SQL> create table tab (col number);

Table created.

SQL> insert into tab (col)
2 select col
3 from tab
4 where not exists (select col from tab where col = 1);

0 rows created.



F.