Saturday, May 5, 2018

Temporary table in PL/SQL, kind of Select into

 create global temporary table temp_raj 
 on commit preserve rows 
 as 
 select * from raj.sal where 1=0 

 insert into temp_raj select * from raj.sal

No comments: