Create temp tables in Stored procedure

• • Reply

  18 years ago

  by jayaprad

  Dolly

  , United States

  Joined 19 years ago

  How can we create temp tables in Oracle Stored procedures ?

  Report abuse
• • Reply

  18 years ago

  by s_h_i_l_p_a

  Shilpa

  , United States

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

  Report abuse