Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL question; Please Help!
I'll have to agree with Gerard, since I've used this SQL construction successfully. Just try it.
On Tue, 21 Oct 1997 20:50:21 -0700, "Ivan Tung" <ivant_at_direct.ca> wrote:
>Thanks for replying
>
>however that is the improper use of the IN keyword.
>In selects records that exists in the list of values in the following
>parentheses, in your example provided by the subquery,
>
>ie. Select * from tablex where b_day in (1970,1971,1972)
>
>Your example would work if you concantenated the values assuming they
are
>not numbers,
>
>ie Delete from t1 where a||b in (select a||b from t2);
>
>however this works only on char fields
>
>
>Gerard H. Pille wrote in message
<01bcde42$34e59440$e81beec3_at_pcghp>...
>>delete from t1 where (a,b) in (select a,b from t2);
>>--
>>Kind reGards,
>>
>>Gerard
>>(ghp_at_santens.be; ghp_at_skynet.be)
>>
>>Ivan Tung <ivant_at_direct.ca> schreef in artikel
>><62hjf0$49l$1_at_brie.direct.ca>...
>>> I have 2 identical tables structures t1, t2.
>>> I essentially want to do an insert and update on t1 from t2.
>>> I plan to delete all rows in t1 that exists in t2 then insert all
the
rows
>>> in t2 into t1.
>>> The deleting is where I am having trouble.
>>
>
Received on Thu Oct 23 1997 - 00:00:00 CDT