SELECT "POBJID","TOBJID","OWNERID","CNAME","LOBPNAME","TSNAME","SGFLAGS","CHUNK","VERSIONP","FLAGS","PROPERTY","TSNO","FILENO","BLOCKNO","DOBJID","INAME","ISGFLAG","ITSNAME","ITSNO","IFILE","IBLOCK","IDOBJID","IINITRANS","IMAXTRANS","COLTYPE","COLTYPFLG","BLOCKSIZE"
FROM sys.exu9lbp
WHERE ownerid = userenv('SCHEMAID')
SELECT "POBJID"
, "TOBJID"
, "OWNERID"
, "CNAME"
, "LOBPNAME"
, "TSNAME"
, "SGFLAGS"
, "CHUNK"
, "VERSIONP"
, "FLAGS"
, "PROPERTY"
, "TSNO"
, "FILENO"
, "BLOCKNO"
, "DOBJID"
, "INAME"
, "ISGFLAG"
, "ITSNAME"
, "ITSNO"
, "IFILE"
, "IBLOCK"
, "IDOBJID"
, "IINITRANS"
, "IMAXTRANS"
, "COLTYPE"
, "COLTYPFLG"
, "BLOCKSIZE"
FROM SYS.EXU9LBP
WHERE OWNERID = USERENV('SCHEMAID')
|
|
|