Community discussion forum

Create temp tables in Stored procedure

• • Reply

  6 years ago

  by jayaprad

  jayaprad

  , United States

  Joined 6 years ago

  How can we create temp tables in Oracle Stored procedures ?

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  6 years ago

  by s_h_i_l_p_a

  s_h_i_l_p_a

  , United States

  Joined 6 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.......

  Report abuse