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: Using a Select as a Var??

Re: Using a Select as a Var??

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 05 Jul 2007 09:11:26 -0700
Message-ID: <1183651886.060090.272930@r34g2000hsd.googlegroups.com>


On Jul 5, 5:50 pm, valigula <valig..._at_gmail.com> wrote:
> Hi All
> Need top repeat a select 3 times but with differents where condition.
> I tried to repeat the selects and after use a couple of union to join
> then, but it takes toooo long.
>
> I also remember there was a way such as:
>
> using var (select stamment)
> select *
> from var
> where .....
>
> but i can not remember the exact syntaxes.
>
> Does anybody know?.
>
> Thanks.

'syntaxes' are looked up in the SQL reference manual, NOT by posting here!!
and it is the WITH statement

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jul 05 2007 - 11:11:26 CDT

Original text of this message

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