Govindan, interesting observation, would you elaborate why you'd choose object over GTT ?? Raj On 8/26/05, GovindanK <gkatteri@xxxxxxxxxxx> wrote: > > If it does not involve too much of volume i would prefer creating an > object type, assiging values to it and select CAST from it. > > HTH > GovindanK > > On Fri, 26 Aug 2005 11:52:23 -0400, "Aggarwal, Meenakshi" > <Meenakshi.Aggarwal@xxxxxxxxxxxxx> said: > > Does anybody know any reason of not using temporary tables in Oracle 9i. > > > > Thanks > > -- > > //www.freelists.org/webpage/oracle-l > -- > //www.freelists.org/webpage/oracle-l > -- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY';