SQL> select table_name from user_tables order by table_name; TABLE_NAME
------------------------------
BIGTABLE
COURSE
EMP
HY_MILLION
HY_MILLION2
SCORE
SMALLTABLE
STUDENT
TB_100MILLION
TB_COURSE
TB_DEPT03
TB_EMP01
TB_EMP02
TB_EMP03
TB_EMP04
TB_MILLION
TB_SC
TB_SCORE
TB_SCORE01
TB_SCORE2
TB_SCORE3
TB_SC_NODUP
TB_SC_NODUP2
TB_STUDENT
TB_TENMILLION
TEST01
TEST02
TEST03
TEST04
TESTCOUNT 已选择30行。 SQL> desc testcount;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
NAME NVARCHAR2(60)
VAL NVARCHAR2(60) SQL>