QUOTE:

SQL> create table t6 as select * from t5;

表已创建。

SQL> select constraint_name,constraint_type from user_constraints where table_na
me=''T6'';

未选定行

QUOTE:

SQL> select rownum,rowid,t6.* from t6;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
1 AAAHROAAKAAAALkAAA 1 2
2 AAAHROAAKAAAALkAAB 2 2
3 AAAHROAAKAAAALkAAC 3 2
4 AAAHROAAKAAAALkAAD 5 3
5 AAAHROAAKAAAALkAAE 4 3
6 AAAHROAAKAAAALkAAF 6 7
7 AAAHROAAKAAAALkAAG 8 6

已选择7行。

SQL> select rownum,rowid,t6.* from t6 order by a;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
1 AAAHROAAKAAAALkAAA 1 2
2 AAAHROAAKAAAALkAAB 2 2
3 AAAHROAAKAAAALkAAC 3 2
5 AAAHROAAKAAAALkAAE 4 3
4 AAAHROAAKAAAALkAAD 5 3
6 AAAHROAAKAAAALkAAF 6 7
7 AAAHROAAKAAAALkAAG 8 6

已选择7行。

SQL> select rownum,rowid,t6.* from t6 order by a desc;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
7 AAAHROAAKAAAALkAAG 8 6
6 AAAHROAAKAAAALkAAF 6 7
4 AAAHROAAKAAAALkAAD 5 3
5 AAAHROAAKAAAALkAAE 4 3
3 AAAHROAAKAAAALkAAC 3 2
2 AAAHROAAKAAAALkAAB 2 2
1 AAAHROAAKAAAALkAAA 1 2

已选择7行。

QUOTE:

SQL> alter table t6 add constraint con_p_t6 primary key (a);

表已更改。

SQL> select rownum,rowid,t6.* from t6;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
1 AAAHROAAKAAAALkAAA 1 2
2 AAAHROAAKAAAALkAAB 2 2
3 AAAHROAAKAAAALkAAC 3 2
4 AAAHROAAKAAAALkAAD 5 3
5 AAAHROAAKAAAALkAAE 4 3
6 AAAHROAAKAAAALkAAF 6 7
7 AAAHROAAKAAAALkAAG 8 6

已选择7行。

SQL> select rownum,rowid,t6.* from t6 order by a;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
1 AAAHROAAKAAAALkAAA 1 2
2 AAAHROAAKAAAALkAAB 2 2
3 AAAHROAAKAAAALkAAC 3 2
4 AAAHROAAKAAAALkAAE 4 3
5 AAAHROAAKAAAALkAAD 5 3
6 AAAHROAAKAAAALkAAF 6 7
7 AAAHROAAKAAAALkAAG 8 6

已选择7行。

SQL> select rownum,rowid,t6.* from t6 order by a desc;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
1 AAAHROAAKAAAALkAAG 8 6
2 AAAHROAAKAAAALkAAF 6 7
3 AAAHROAAKAAAALkAAD 5 3
4 AAAHROAAKAAAALkAAE 4 3
5 AAAHROAAKAAAALkAAC 3 2
6 AAAHROAAKAAAALkAAB 2 2
7 AAAHROAAKAAAALkAAA 1 2

已选择7行。

QUOTE:

SQL> select rownum,rowid,t6.* from t6 order by b;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
1 AAAHROAAKAAAALkAAA 1 2
2 AAAHROAAKAAAALkAAB 2 2
3 AAAHROAAKAAAALkAAC 3 2
4 AAAHROAAKAAAALkAAD 5 3
5 AAAHROAAKAAAALkAAE 4 3
7 AAAHROAAKAAAALkAAG 8 6
6 AAAHROAAKAAAALkAAF 6 7

已选择7行。

SQL> select rownum,rowid,t6.* from t6 order by b desc;

ROWNUM ROWID A B C
---------- ------------------ ---------- ---------- ----------
6 AAAHROAAKAAAALkAAF 6 7
7 AAAHROAAKAAAALkAAG 8 6
4 AAAHROAAKAAAALkAAD 5 3
5 AAAHROAAKAAAALkAAE 4 3
1 AAAHROAAKAAAALkAAA 1 2
2 AAAHROAAKAAAALkAAB 2 2
3 AAAHROAAKAAAALkAAC 3 2

已选择7行。