Oracle equalivent of a Sybase's ISQL for Select Into Trick

Hi,

In Sybase,

I can do select * into new_table from old_table where 1=0;

This will create the empty new_table which the column name and data definition the same as the old_table.

Is there a equivalent trick in Oracle to do so?

Thanks,

Edmond Received on Fri Dec 15 2006 - 09:05:25 CST