Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL help (create table)

Re: SQL help (create table)

From: Jean-Baptiste Jacquemard <jb.jacquemard_at_pollak-prebon.fr>
Date: Mon, 03 Jun 2002 16:50:54 +0200
Message-ID: <3CFB824E.61456C5@pollak-prebon.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US