Re: CHOOSE and ALL_ROWS

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Tue, 26 Oct 2010 09:10:23 +0300
Message-ID: <AANLkTinihf=MfK9sCikdM74TGwCT-NNiAOnRSPxxsadm_at_mail.gmail.com>



Here is a reasoning exactly about that:
http://jonathanlewis.wordpress.com/2008/11/11/first_rows_n/

Gints Plivna
http://www.gplivna.eu

2010/10/26 Aragon, Gabriel (GE, Corporate, consultant) <gabriel.aragon_at_ge.com>:
> Hi,
>
> I know that CHOOSE has to be removed in 10g and use FIRST_ROWS_n or
> ALL_ROWS, but is it true that ALL_ROWS is only for DWH? anyone using
> ALL_ROWS for a non DWH environment who can share behaviour?
>
>
> tks
>
>
> Gabriel
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2010 - 01:10:23 CDT

Original text of this message