Re: select into another table

William schrieb:

> 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!

If the table does exist:

insert into tab_a (column_a, column_b, ...) select dat_for_col_a, dat_for_col_b, ... from ....
where ....

If you want to create the table with the select-statement:

create table tab_a as
<select-statement>

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------