Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL help (create table)
Thanks a lot.
Pieter wrote:
> CREATE TABLE new_table_1 AS
> SELECT col_1, col_2 FROM wxisting_table;
>
> The new columns inherit the data type
Received on Mon Jun 03 2002 - 09:50:54 CDT