Re: conditional insert with values; insert into .. values(...) where not exist (....);
- From: Peter Nilsson <airia@xxxxxxxxxxx>
- Date: Tue, 29 Apr 2008 20:27:31 -0700 (PDT)
md wrote:
This is what I wish I could to do.
insert into table_x (a, b, c)
values(1, 2, 3)
where not exist (select * from table_x where a = 2);
Thank you.
Look up 'insert when'.
--
Peter
.
- References:
- Prev by Date: Re: regexp_substr help, please
- Next by Date: How to calculate time difference excluding weekends (saturday and sunday)
- Previous by thread: conditional insert with values; insert into .. values(...) where not exist (....);
- Next by thread: Re: conditional insert with values; insert into .. values(...) where not exist (....);
- Index(es):
