Re: MS-SQL -> Oracle SELECT INTO conversion problem...

Hi,

did you try :
create table new_table as
select ....

Greetings
timo

"Slawek L." wrote:
>
> Under MS-SQL (T-SQL) Select statement is defined as follows:
>
> SELECT select_list
> [INTO new_table_]
> ^^^^^^^^^^^^^^^^^^^^^
> FROM table_source
> [WHERE search_condition]
> [GROUP BY group_by_expression]
> [HAVING search_condition]
> [ORDER BY order_expression [ASC | DESC] ]
>
> Q:How under PL/SQL can one redirect sorted results from SELECT query to
> another table.
>
> Slawek

--

+---+---+-+-+-+-+
|   |   |-+-+-+-+ Fraunhofer-Institut fuer Graphische Datenverarbeitung
+---+---+-+-+-+-+ Fraunhofer-Institute for Computer Graphics
|   |   |-+-+-+-+ Abteilung / Department : Document Imaging  
+---+---+-+-+-+-+
|      __   _   | Timo Biesenbach
|  !  ! _  ! \  | Rundeturmstr. 6      phone  ++49 6151 155 578
|  !  !__! !_/  | 64283 Darmstadt      fax    ++49 6151 155 299 
+---------------+ Germany              email  timo.biesenbach_at_igd.fhg.de