Re: insert as select

What do you have to gain be ordering your inserts?

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 - 14:21:01 CDT