venkat82.k

 Profile Answers by venkat82.k 

• Mar 20th, 2008

 

Hi guys........
Temporary tables means which tables are hold data temporarly
i mean these holds the data certain time mainly only that session.
exp:-

• create global temporary table employ(emp_id number(10),employ_name varchar2(20)) on commit delete/on commit preserve;

this is brief desc of temporary table okkkkkkkkkkk
any queries reanswer plsssss

ravi.8311

 Profile Answers by ravi.8311 

• Jun 28th, 2008

 

create table temp as select*from base table where 1=1;