CREATE A TEMPORARY TABLE AS FOLLOWS

2. - OCA /OCP ORACLE DATABASE 11G A LL-IN-ONE EXAM GUIDE- P32 POT
OCA /OCP ORACLE DATABASE 11G A LL-IN-ONE EXAM GUIDE- P32 POT
2. Create a temporary table as follows:

create global temporary table tmp_emps on commit preserve rows

as select * from employees where 1=2;