SQL> select * from (select * from t1 order by id ) where rownum<20;
ID A1 A2 A3
---------- ---------- ---------- ----------
1 1 1 a1
10 10 10 a10
100 100 100 a100
1000 1000 1000 a1000
10000 10000 10000 a10000
1001 1001 1001 a1001
1002 1002 1002 a1002
1003 1003 1003 a1003
1004 1004 1004 a1004
1005 1005 1005 a1005
1006 1006 1006 a1006
ID A1 A2 A3
---------- ---------- ---------- ----------
1007 1007 1007 a1007
1008 1008 1008 a1008
1009 1009 1009 a1009
101 101 101 a101
1010 1010 1010 a1010
1011 1011 1011 a1011
1012 1012 1012 a1012
1013 1013 1013 a1013
SQL> select * from (select * from t2 order by id ) where rownum<20;
ID A1 A2 A3
---------- ---------- ---------- ----------
1 1 1 a1
2 2 2 a2
3 3 3 a3
4 4 4 a4
5 5 5 a5
6 6 6 a6
7 7 7 a7
8 8 8 a8
9 9 9 a9
10 10 10 a10
11 11 11 a11
ID A1 A2 A3
---------- ---------- ---------- ----------
12 12 12 a12
13 13 13 a13
14 14 14 a14
15 15 15 a15
16 16 16 a16
17 17 17 a17
18 18 18 a18
19 19 19 a19
已选择19行。
SQL> select dbms_metadata.get_ddl('TABLE','T1') from dual;
DBMS_METADATA.GET_DDL('TABLE','T1')
--------------------------------------------------------------------------------
CREATE TABLE "TEST"."T1"
( "ID" CHAR(10),
"A1" CHAR(10),
"A2" CHAR(10),
"A3" CHAR(10),
PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE S
SQL>
select dbms_metadata.get_ddl('TABLE','T2') from dual;SQL>
DBMS_METADATA.GET_DDL('TABLE','T2')
--------------------------------------------------------------------------------
CREATE TABLE "TEST"."T2"
( "ID" NUMBER(*,0),
"A1" CHAR(10),
"A2" CHAR(10),
"A3" CHAR(10),
PRIMARY KEY ("ID") ENABLE
) ORGANIZATION INDEX NOCOMPRESS PCTFREE 10 IN