Home » SQL & PL/SQL » SQL & PL/SQL » what is the equivalent of temporary table of sql server in oracle
what is the equivalent of temporary table of sql server in oracle [message #37198] Wed, 23 January 2002 23:58 Go to next message
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)
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 Go to previous message
dinakar shetty
Messages: 29
Registered: January 2002
Junior Member
create global temprovary table name
(
..
..
)
delete on commit
Previous Topic: variable in implicit cursor problem
Next Topic: dynamic sql
Goto Forum:
  


Current Time: Fri Jul 23 11:26:45 CDT 2021