Database Reference
In-Depth Information
EODA@ORA12CR1> desc image_load
Name Null? Type
---------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(255)
IMAGE ORDSYS.ORDIMAGE
EODA@ORA12CR1> desc ordsys.ordimage
Name Null? Type
----------------------------------------------------- -------- -------------------------------
SOURCE ORDSYS.ORDSOURCE
HEIGHT NUMBER(38)
WIDTH NUMBER(38)
CONTENTLENGTH NUMBER(38)
FILEFORMAT VARCHAR2(4000)
...
EODA@ORA12CR1> desc ordsys.ordsource
Name Null? Type
----------------------------------------------------- -------- -------------------------------
LOCALDATA BLOB
SRCTYPE VARCHAR2(4000)
SRCLOCATION VARCHAR2(4000)
SRCNAME VARCHAR2(4000)
UPDATETIME DATE
...
■
You could issue
SET DESC DEPTH ALL
or
SET DESC DEPTH <n>
in SQL*plus to have the entire hierarchy
displayed at once. given that the output from describing the
ORDSYS.ORDIMAGE
type would have been many pages long,
i chose to do it piece by piece.
Note
