sort - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

sort

sort# Database - 数据库

a*w2000-08-04 07:08

1 楼

Thanks for the previous answer about the debugging PL/SQL.
In Oracle, I want to sort one table and put all the data
into
another table. Without using PL/SQL, almost impossible?
Any DX has any idea about that?
Thx.

b*e2000-08-04 07:08

2 楼

how can you sort data in a table? i don't believe they're
stored in a sequential way. when you retrievfe data using
sql, you can always specify sorting order

【在 a**w 的大作中提到】

: Thanks for the previous answer about the debugging PL/SQL.
: In Oracle, I want to sort one table and put all the data
: into
: another table. Without using PL/SQL, almost impossible?
: Any DX has any idea about that?
: Thx.

ug2000-08-04 07:08

3 楼

don't ORCL well, but can you just use:
insert into new_table ( select * from old_table order by ... ) ?
maybe my point is dumn :(

【在 b****e 的大作中提到】

: how can you sort data in a table? i don't believe they're
: stored in a sequential way. when you retrievfe data using
: sql, you can always specify sorting order

a*w2000-08-04 07:08

4 楼

When use insert into, you can not use order by.

【在 ug 的大作中提到】

: don't ORCL well, but can you just use:
: insert into new_table ( select * from old_table order by ... ) ?
: maybe my point is dumn :(

a*w2000-08-04 07:08

5 楼

I want the data in the sorting order in the table for future
special joining, which requires the order.
Any idea?

【在 b****e 的大作中提到】

: how can you sort data in a table? i don't believe they're
: stored in a sequential way. when you retrievfe data using
: sql, you can always specify sorting order

b*e2000-08-04 07:08

6 楼

sorry i don't understand this.. what kind of special join
do you mean?

【在 a**w 的大作中提到】

: I want the data in the sorting order in the table for future
: special joining, which requires the order.
: Any idea?