Re: select into another table

thanks mr. wise guy!

Wise Guy wrote:

> Create Table <table name> as
> Select distinct <columnA, columnB...>
> from tableX
> where...
>
> William wrote in message <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:24:41 CST