Re: dynamic table creation

"Krzys!" <krzys78_at_polbox.com> wrote in message news:bgd2nq$1oi5$1_at_foka.acn.pl...
> True :-) I used to working with TSQL and I'm a begginer in Oracle.
> Anyway I try to figure out with temporary tables but if someone else
> have other suggestion how to solve my problem please help !!!!
>
>
> K.
>
>
>
> Jim Kennedy wrote:
> > "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
> >
> >
>

Ah, resorting to bad habits. In those environments you have to use temporary tables. In Oracle just try selecting the data, don't bother with temporary tables. It will only slow you down. In all my years in using Oracle - dba and application developer and it is over 10 years of experience - I have only come accros one instance where global temporary tables where the answer. At the time they did not exist, so we just used a regular table and created it once for everyone.

Oracle!=SQLServer. About 2 different beasts as you can have. In Oracle readers don't block writers and writers don't block readers. No really they don't. You have a lot to learn that things are done much easier in Oracle. Jim Received on Fri Aug 01 2003 - 12:16:42 CEST