Re: Temporary Tables - 3 of 3
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: "rjamya" <rjamya@xxxxxxxxx>
- Date: Fri, 26 Aug 2005 11:15:46 -0700
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@xxxxxxxxx> said:
> 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';
--
//www.freelists.org/webpage/oracle-l
Other related posts:
