Re: Need SQL Server Temp Table equivalent (challenge!)

Brian,

I read thru the doc and found that a temp file requires a fixed format (fixed # and type of columns). The key for my temp table need is dynamic columns.

Kin

>Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message >news:<3F12BCD2.A768AFE4_at_remove_spam.peasland.com>...
> Have a look at Global Temporary Tables. You can find more information in
> the Oracle docts (http://technet.oracle.com).
>
> HTH,
> Brian
>
> Kin Ng wrote:
> >
> > I have a need to create a temp table for a session only. The temp
> > table's structure is not fixed. Thus the current Oracle temp session
> > table won't work.
> >
> > Let me explain why I need this. Our business requirement is to have
> > dynamic product attributes. I.e. the product's attribute is user
> > defined. I have a table that stores row wise for each attribute (say
> > Brand) what the values will be (say Ford). Thus the user can define
> > as many attributes as they need. Here is the simplified table:
> >
> > Product Attribute Value
> > ---------------------------
> > Sparkplug1 Brand Ford
> > Sparkplug2 Brand GM
> > Sparkplug1 Size Big
> > Sparkplug2 Size Small
> > Sparkplug1 Weight Heavy
> > Wiper1 Brand Acura
> > Wiper1 Size Long
> > Wiper2 Brand GM
> > Wiper2 Size Small
> > Wiper3 Brand Ford
> >
> > Now the tricky part, the user expects to see their definition as this
> > from a View that I need to create:
> >
> > Product Brand Size Weight
> > ------------------------------------
> > Sparkplug1 Ford Big Heavy
> > Sparkplug2 GM Small null
> > Wiper1 Acura Long null
> > Wiper2 GM Small null
> > Wiper3 Ford null null
> >
> > This is almost like a pivot table but I need to do this dynamically.
> > If I can create a table (may I say like the SQL Server temp table) and
> > fill this table and return it, the whole world will be happy.
> >
> > So how can I do this in Oracle?
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Mon Jul 14 2003 - 14:35:39 CDT