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

Home -> Community -> Usenet -> c.d.o.server -> Re: delete with 'from' clause

Re: delete with 'from' clause

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 27 May 1999 22:27:10 +0200
Message-ID: <927836732.8290.0.pluto.d4ee154e@news.demon.nl>


Hi Kent,
No and Yes
No , not in this way.
Yes, you should transform all your joins in subqueries and it will work.

Hth,

Sybrand Bakker, Oracle DBA

Kent Eilers wrote in message <374DA5A3.7E554F6D_at_pca.state.mn.us>...
>In Transact SQL-Server you could do the following:
>
>delete table_x
>from table_x, table_y, table_z
>where blah...blah
>
>Can this be accomplished in Oracle?
>
>Thanks.
>
Received on Thu May 27 1999 - 15:27:10 CDT

Original text of this message

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