Re: Sub-query in Oracle cursor

From: Andreas Wenzel <dummy_at_dummy.org>
Date: Mon, 12 Aug 2002 08:57:34 +0200
Message-ID: <v8m7ja-nf1.ln@pc27.delphi.at>

Hi!

I'd prefer this syntax:

CURSOR MyCursor IS
SELECT

    B.MyCount,
    A.Column1,
    A.Column2

FROM Table1 A, (SELECT COUNT(*) MyCount FROM Table1) B;

This syntax works since derrived tables are supported in Oracle.

Cheers, Andreas

Ola wrote:

> CURSOR MyCursor IS
> SELECT
> (SELECT COUNT(*) FROM Table1) MyCount ,
> Column1,
> Column2
> FROM Table1;

-- 
My real eMail is "a dot wenzel at aon dot at"

Received on Mon Aug 12 2002 - 01:57:34 CDT