Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Ordered INSERT...INTO or UPDATE
insert into table_b as select number_field from table_a order by
number_field;
Starman wrote:
>
> In there a way to insert data from a table o another ordering data?
>
> For example I have a table containing:
>
> Number
> --------
> 40
> 10
> 20
> 30
>
> I want to insert in another table:
>
> Number
> --------
> 10
> 20
> 30
> 40
>
> Another solution is to have another field (ord for example) for ordering
> data. But how can I do an UPDATE setting the order in this field from
> smaller to bigger number?
>
> Help me please!
>
> --
> Nino Stella
> Inteldata Srl
> email: ninomail_at_tin.it
Received on Wed Dec 01 1999 - 10:53:19 CST