Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ***Help***Complex SQLs

Re: ***Help***Complex SQLs

From: Vasco Patricio <vpatricio_at_abrantina.pt>
Date: 16 Dec 1998 18:21:29 GMT
Message-ID: <01be2921$2c1b5180$370a0a0a@vpatricio>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US