Re: select into another table

From: Tom Verhagen <tverhage_at_bart.nl>
Date: Thu, 4 Nov 1999 22:48:44 +0100
Message-ID: <7vsulg$nmu$1@freyja.bart.nl>

create newtable as select distinct field1,field2,.... from othertable; William heeft geschreven in bericht <3821D207.B983502E_at_nopenopenope.com>...
>I found some syntax last week on technet.oracle.com which would take a
>select statement resultset and output into a new table.
>however, i can't seem to find the syntax now. can someone help me out?
>
>i need to select all unique from tableone and output into a new tabletwo
>
>thanks!
>
Received on Thu Nov 04 1999 - 15:48:44 CST