Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create temporary table in PL/SQL block

Re: How to create temporary table in PL/SQL block

From: Naguib Younes <ynaguib_at_videotron.ca>
Date: 2000/07/06
Message-ID: <SO995.634$Z01.11596@weber.videotron.net>#1/1

Use DBMS_SQL, you can execute any sql from it in a pl-sql, as long as you have the proper grants.

Hope it helps
NY
Meghdeep <meghdeep_at_hotmail.com> wrote in message news:8k2q8d$51c$1_at_news.chatlink.com...
>
> I need to to create a multi column temporary table in stored procedure and
> want to drop at end of it. How will I do it?
>
> I am using oracle 8.05 on windows NT.
>
> Thanks,
> Meghdeep
>
>
>
Received on Thu Jul 06 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US