Create temp tables in Stored procedure

oracle United States
  • 18 years ago

    How can we create temp tables in Oracle Stored procedures ?

  • 18 years ago

    what do  u mean by TEMP tables?
    do u mean PL/SQL tables or normal tables?


    if u want to creat pl/sql tables, then u can just do it in the declare portion.
    but if u want to create normal tables and then delete them then u have to import a package which is -- dbms_ddl


    hope this helps u out.......

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Better train people and risk they leave – than do nothing and risk they stay.” - Anonymous