Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Help
Sorry, I didn't finish off the demo query. Here is the message again:
I'm in the process of rewriting some Transact SQL Sybase code to Oracle PL/SQL. Oracle does not appear to accept embedded subqueries of the form:
select * from TABLE_A
WHERE
(VAL1 - (select VAL2 from TABLE_B)) > 0;
(i know this can be rewitten as select (COL_A,COL_B...) from TABLE_A,TABLE_B where VAL1 > VAL2 but the actual queries are more complex and I'd rather not rewrite then in this form if I can help it
Thanks
Paul
Paul Wiles wrote in message <371c965d_at_newsread3.dircon.co.uk>...
>I'm in the process of rewriting some Transact SQL Sybase code to Oracle
>PL/SQL.
>
>Oracle does not appear to accept embedded subqueries of the form:
>
>select * from TABLE_A
> WHERE
> (VAL1 - (select VAL2 from TABLE_B)
>
>(i know this can be rewitten as select (COL_A,COL_B...) from
TABLE_A,TABLE_B
>where VAL1 > VAL2 but the actual queries are more complex and I'd rather
not
>rewrite then in this form if I can help it
>
>Thanks
>
>Paul
>
>
Received on Tue Apr 20 1999 - 10:25:22 CDT