I m converting stored proc from sql server to oracle.
first have a look sql stored proc.
create procedure xyz..
-- i have created one temp table
-- then inserted some data into it by select query over some db table.
-- then i have another temp table
-- then some recored gets inserted into second temp table by help of first temp table and some