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

From: <michael_bialik_at_my-deja.com>
Date: Thu, 22 Jul 1999 20:20:58 GMT
Message-ID: <7n7uet$4qm$1@nnrp1.deja.com>

Hi.

Try :

INSERT INTO new_table ( field1, field2, field3, ... ) SELECT f1, f2,SUM( f3), ...

     FROM old_table
     WHERE f4 = parm1
     GROUP BY f1,f2,...

( Check Oracle SQL Reference for INSERT command ).

Michael.

In article <7n57e8$mt8$1_at_iceman.tac.net>, "Slawek L." <slisznianski_at_cucentral-ab.com> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 22 1999 - 15:20:58 CDT