Creation of Oracle temporary table with same table structure to that of a existing table

Question

How to create a global temporary table with same table structure to that of a existing table?

I know this concept is available in SQL server like "select * into #temp123 from abc". But I want to perform the same in Oracle.

Answer 1

Create global temporary table mytemp 
as 
select * from myTable
where 1=2