【예제】
SQL> desc all_snapshots;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
MASTER_VIEW VARCHAR2(30)
MASTER_OWNER VARCHAR2(30)
MASTER VARCHAR2(30)
MASTER_LINK VARCHAR2(128)
CAN_USE_LOG VARCHAR2(3)
UPDATABLE VARCHAR2(3)
REFRESH_METHOD VARCHAR2(11)
LAST_REFRESH DATE
ERROR NUMBER
FR_OPERATIONS VARCHAR2(10)
CR_OPERATIONS VARCHAR2(10)
TYPE VARCHAR2(8)
NEXT VARCHAR2(200)
START_WITH DATE
REFRESH_GROUP NUMBER
UPDATE_TRIG VARCHAR2(30)
UPDATE_LOG VARCHAR2(30)
QUERY LONG
MASTER_ROLLBACK_SEG VARCHAR2(30)
STATUS VARCHAR2(7)
REFRESH_MODE VARCHAR2(8)
PREBUILT VARCHAR2(3)
SQL> select count(*) from all_snapshots;
COUNT(*)
----------
2
SQL>