CHOOSE and ALL_ROWS

From: Aragon, Gabriel (GE, Corporate, consultant) <"Aragon,>
Date: Mon, 25 Oct 2010 19:11:05 -0400
Message-ID: <5409709395C6884598ADE701EDED9ACD05CF2BF4_at_CINMLVEM17.e2k.ad.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 Mon Oct 25 2010 - 18:11:05 CDT

Original text of this message