Re: dynamic table creation
Date: 31 Jul 2003 10:07:42 -0700
Message-ID: <92eeeff0.0307310907.56f520f0_at_posting.google.com>
"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in message news:<E3aWa.19502$cF.8390_at_rwcrnsc53>...
> "Krzys!" <krzys78_at_polbox.com> wrote in message
> news:bgb7kv$13tn$1_at_foka1.acn.pl...
> > I'd like to create a table dynamicly. List of column in this table
> > should be taken from select: "select distinct fiel from table "
> >
> > How to do it ?
> >
> >
> > tnx in advance for help
> > K.
> >
> >
> >
> >
> > --
> > Używam MozilliPL, a Ty? MozillaPL: http://www.MozillaPL.org
> >
> It is rare that in Oracle you would ever need to do this. Usually people
> who feel they need to do this are from a SQLServer or Sybase background. If
> you feel that you must do this look up global temprorary tables in the
> documentation.
> Jim
To add to above and just so that you know that it CAN be done in Oracle, Visit http//tahiti.oracle.com and lookup dynamic sql. Use dbms_sql search keyword.
Regards
/Rauf Sarwar
Received on Thu Jul 31 2003 - 19:07:42 CEST