SQL> col object_name format a30;
SQL> col segment_type format a30;
SQL> col segment_name format a30;
SQL> col object_type format a30;
SQL> select segment_name,segment_type from user_segments;
SEGMENT_NAME
SEGMENT_TYPE
------------------------------ ------------------------------
DEPT
TABLE
EMP
TABLE
SALGRADE
TABLE
STUDENT
TABLE
CDPT
TABLE
T_USER
TABLE
PK_DEPT
INDEX
PK_EMP
INDEX
SYS_C0011233
INDEX
PK_ID
INDEX
已选择10行。
SQL> select object_name,object_type from user_objects;
OBJECT_NAME
OBJECT_TYPE
------------------------------ ------------------------------
PK_DEPT
INDEX
DEPT
TABLE
EMP
TABLE
PK_EMP
INDEX
BONUS
TABLE
SALGRADE
TABLE
T_USER
TABLE
STUDENT
TABLE
SYS_C0011233
INDEX
CDPT
TABLE
SEQEMP
SEQUENCE
OBJECT_NAME
OBJECT_TYPE
------------------------------ ------------------------------
PK_ID
INDEX
已选择12行。