SQL & PL/SQL

Hello!

is it possible to create a local temporary table with the structure of another table?

Without specifying each column,

Not like that:

CREATE TABLE #tempSessionC 
( 
  Column1  INT   NOT NULL , 
  Column2  NVARCHAR(4000) 
);

But something like

CREATE TABLE #tempSessionC  otherTable%type


Thanks in advance for your help

frenchcancan