ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 11th, 2007

 

A temporary table is a table where data is stored temporarily during execution of a session and it is deleted as soon as session is over or commit is done. For example a

create global temporary table Name_Des
(
emono  VARCHAR2(12),
ename VARCHAR2(100),
hire_date  DATE,
job    VARCHAR2(10),
)
on commit delete rows;