DBA Data[Home] [Help]

VIEW: SYS.EXU9LOBU

Source

View Text - Preformatted

SELECT  "TOBJID","OWNERID","CNAME","SNAME","SSGFLAG","STSNAME","STSNO","SFILE","SBLOCK","SDOBJID","SCHUNKING","SVPOOL","SFLAGS","INAME","ISGFLAG","ITSNAME","ITSNO","IFILE","IBLOCK","IDOBJID","IINITRANS","IMAXTRANS","SPROPERTY","COLTYPE","COLTYPFLG","BLOCKSIZE","INTCOLID","OPAQUETYPE","IFREEPOOL"
        FROM    sys.exu9lob
        WHERE   ownerid = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT "TOBJID"
, "OWNERID"
, "CNAME"
, "SNAME"
, "SSGFLAG"
, "STSNAME"
, "STSNO"
, "SFILE"
, "SBLOCK"
, "SDOBJID"
, "SCHUNKING"
, "SVPOOL"
, "SFLAGS"
, "INAME"
, "ISGFLAG"
, "ITSNAME"
, "ITSNO"
, "IFILE"
, "IBLOCK"
, "IDOBJID"
, "IINITRANS"
, "IMAXTRANS"
, "SPROPERTY"
, "COLTYPE"
, "COLTYPFLG"
, "BLOCKSIZE"
, "INTCOLID"
, "OPAQUETYPE"
, "IFREEPOOL"
FROM SYS.EXU9LOB
WHERE OWNERID = USERENV('SCHEMAID')