Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ***Help***Complex SQLs
What I think u need (I could be wrong) is something like:
(1)
SELECT UNIQUE (col1, col2, ..., colN) WHERE .... GROUP BY col1, col2, ..., colN
(2)
UPDATE ... WHERE col IN (SELECT - query1) OR col IN (SELECT - query2) OR ..
The "SELECT - queryN" queries are the conditions of your if-statement.
Ass:
>V<
Received on Wed Dec 16 1998 - 12:21:29 CST