> > Can I use SQL-92 SELECT * INTO NEW_TABLE FROM EXIST_TABLE ???
>
> Only if new_table has identical structure to exist_table

Wouldn't the syntax then be

INSERT INTO NEW_TABLE SELECT * FROM EXIST_TABLE?

I thought he was asking if it was allowed to mix DDL and DML within
one statement, and I must say I am a bit surprised if it is true that
the SQL-92 standard specifies this - even if it occationally would be
a convenient shortcut.

Set