Re: Temporary Tables - 3 of 3

Memory processing is any time faster than table handling. Lesser maintenance.
As i have mentioned in 1 of 3 and 2 of 3 one need not have to bother about on commit preserve/delete.
You can select multiple times within the same session and the values are avbl to you.

HTH
GovindanK

On Fri, 26 Aug 2005 12:41:05 -0400, "rjamya" <rjamya_at_gmail.com> said:
> Govindan, interesting observation, would you elaborate why you'd choose
> object over GTT ??
>
> Raj
>
> On 8/26/05, GovindanK <gkatteri_at_fastmail.fm> 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_at_fishersci.com> said:
> > > Does anybody know any reason of not using temporary tables in Oracle 9i.
> > >
> > > Thanks
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
>
>
> --
> ------------------------------
> select standard_disclaimer from company_requirements where category =
> 'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l