Re: Help! Question on PL/SQL

Thanks for the help!

Can I put the "create table temp1 as select .... from .... where ....." into a stored procedure/function on the server?? I got the error when I was trying to do this:

PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:

   begin declare end exception exit for goto if loop mod null    pragma raise return select update while <an identifier

Any idea/help will be greatly appreciated!!

Dana
dan_jian_at_hotmail.com

Andreas Michler <Andreas.Michler_at_adicom.de> wrote in message news:3887301D.38E238D0_at_adicom.de...
> I think you mean temp-tables.
> In this way oracle doesn't have any temp Tables.
> You can do it in the following way
> create table temp1 as select .... from .... where .....,;
> create table temp2 as select .... from .... where ....;
>
> Don't forget to drop the table temp1,temp2,,,, manually. The will not be
> droppped automatically.
>
>
> Dana Jian wrote:
>
> > Hi,
> >
> > I'm converting one procedure from SQL server to Oracle procedure.
> >
> > Here's the simplified statements in the SQL proc,
> >
> > SELECT ... INTO #temp1 FROM....WHERE..
> >
> > SELECT ... INTO #temp2 FROM... WHERE
> >
> > SELECT ... FROM #temp1, #temp2 , .... WHERE ...
> >
> > How to do this in Oracle PL/SQL?
> >
> > Any comments/help will be highly appreciated!!
> >
> > Dana
> > djian_at_trasa.com
>
> --
> -------------------------------------
> ADICOM Informatik GmbH
> Andreas Michler
> Wiesfleckenstr. 34
> 72336 Balingen
> Tel: 07433/9977-57,Fax: -90
> E-Mail: Andreas.Michler_at_adicom.de
> http:\\www.adicom.de
> -------------------------------------
>
>
Received on Thu Jan 20 2000 - 17:07:40 CST