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

From: Slawek L. <slisznianski_at_cucentral-ab.com>
Date: Wed, 21 Jul 1999 13:33:04 -0600
Message-ID: <7n57e8$mt8$1@iceman.tac.net>

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 Received on Wed Jul 21 1999 - 14:33:04 CDT