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: easy question...i think

Re: easy question...i think

From: Tim Witort <trwNOSPAM_at_NOSPAMmedicalert.org>
Date: 1997/09/16
Message-ID: <341F1F3F.B@NOSPAMmedicalert.org>#1/1

Satar Naghshineh wrote:
>
> 15-SEPT-97
>
> Oracle 7.2.3
> sun OS 2.5.1
>
> Hi,
> I want to transfer current table data into two new tables, then create a
> view based on the two new tables. I would I go about doing that in 1
> 24/7 shop? Thanks in advance,
> Satar Naghshineh
> SatarNag_at_worldsite.com
>
> P.S. I will post more Oracle Worldwide Support's FAQs as soon as I can
> find the time.

Examine the SQL Language Reference Manual on the CREATE TABLE command:

CREATE TABLE copy1 AS SELECT * FROM origTable; CREATE TABLE copy2 AS SELECT * FROM origTable;

Received on Tue Sep 16 1997 - 00:00:00 CDT

Original text of this message

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