OraFAQ Forum: SQL & PL/SQL » what is the equivalent of temporary table of sql server in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » what is the equivalent of temporary table of sql server in oracle

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

what is the equivalent of temporary table of sql server in oracle [message #37198]

Wed, 23 January 2002 23:58

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,

Can anyone give me the code equivalent to this in oracle pl/sql.
The below code is from sql server and i want to re create this in oracle pl/sql.its very urgent..

-- Create temp table that will store intermediate data before updating hrc_build_tree
CREATE TABLE #tblUpChain
(
UpID INT NOT NULL IDENTITY(1, 1),
DEPTID VARCHAR (11) NULL,
PARENTID varchar (11) NULL,
UpChain VARCHAR(255) NULL
)
-- Fill hrc_build_tree with dept_security data from pstreenode - intention is to then update the upchain field in the table
INSERT #tblUpChain (DEPTID, PARENTID)

Report message to a moderator

Re: what is the equivalent of temporary table of sql server in oracle [message #37204 is a reply to message #37198]

Thu, 24 January 2002 04:45

dinakar shetty
Messages: 29
Registered: January 2002

Junior Member

create global temprovary table name
(
..
..
)
delete on commit

Report message to a moderator

Previous Topic:	variable in implicit cursor problem
Next Topic:	dynamic sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 02:52:59 CDT 2024