How to create temporary table? Give some example

ravi.8311

 Profile Answers by ravi.8311 Questions by ravi.8311

• Jun 28th, 2008

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

venkat82.k

 Profile Answers by venkat82.k Questions by venkat82.k

• Mar 20th, 2008

Hi guys........Temporary tables means which tables are hold data temporarlyi mean these holds the data certain time mainly only that session.exp:-create global temporary table employ(emp_id number(10)...

Answer Question  Select Best Answer