Re: SQL works in 10g, not in 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Sep 2005 20:09:29 +0200
Message-ID: <l7egj1pid0s3h7926nl9tt0cpbi4n0i449@4ax.com>

On 26 Sep 2005 10:22:53 -0700, rgiannic_at_gmail.com wrote:

>What is wrong with it. How should I change it.
>Spent a few hours on it, and still can't figure it out.
>The rest of the query is fine. If I replace the subquery by 1,
>everything is okay.
>The subquery by itself is also ok.
>
>Can you help?

Just make an inline view of what you call a 'subquery' (and actually isn't), in the FROM list of your statement.

select ....
from ....,
(select ....

 from
)
etc.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Sep 26 2005 - 13:09:29 CDT