OraFAQ Forum: SQL & PL/SQL » Temporary Table

Home » SQL & PL/SQL » SQL & PL/SQL » Temporary Table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temporary Table [message #20725]

Sat, 15 June 2002 13:50

Obede F. Souto
Messages: 5
Registered: June 2002

Junior Member

How can I use a temporary table in an Oracle Stored Procedure?
Please, send me an example.

Report message to a moderator

Re: Temporary Table [message #20729 is a reply to message #20725]

Sun, 16 June 2002 07:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if you are looking for global temp tables,
this may help you.
SQL> CREATE OR REPLACE Procedure tempTable
2 as
3 str varchar2(1000);
4 ttable varchar2(80);
5 BEGIN
6 tTable := 'TempTab';
7 str := 'CREATE GLOBAL TEMPORARY TABLE ' || tTable ||
8 '(Field1 DATE ) ON COMMIT DELETE ROWS';
9 EXECUTE IMMEDIATE str;
10 END;
11 /

Procedure created.

SQL>

Report message to a moderator

Previous Topic:	how to dynamically declare a cursor based on the parameter passed to the proc!!!!!
Next Topic:	oracle+vb+oo4o ------------------plz help me to initiaate--------------

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:46:32 CDT 2024