Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: insert as select

Re: insert as select

From: Andrew Babb <andrewb_at_mail.com>
Date: Mon, 26 Apr 1999 20:22:02 +0800
Message-ID: <37245A6A.12C34C6C@mail.com>


Hi,

Oracle does not worry about storing data in any particular order, and this is why you can not put an ORDER BY statement on an Insert statement.

Hope this helps,
Andrew

Ysteric's wrote:

> Ii there anybody to tell me why :
>
> insert into rubriques
> select r1.code c, r1.code_mere, r1.niveau, 0, 0, r1.libelle
> from rubr r1
> order by c
>
> does not work, but :
> insert into rubriques
> select r1.code c, r1.code_mere, r1.niveau, 0, 0, r1.libelle
> from rubr r1
>
> works quit well !!!
>
> whats wrong with the "order by" clause
>
> thanks everybody
>
> Eric from PARIS - FRANCE
Received on Mon Apr 26 1999 - 07:22:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US