SELECT owner, ownerid, name, table_name, master_view, master_link,
mtime, can_use_log, error, type, query, flag, rowid_snap,
primkey_snap, update_snap, update_trig, update_log, mastabs,
masver, lob_vector, snapshot, snapid, instsite, flavor_id,
3, sql_ver
FROM exu9snap
WHERE BITAND(NVL(flag, 0), 16) + /* supported snapshots: rowid */
BITAND(NVL(flag, 0), 32) + /* primary key */
BITAND(NVL(flag, 0), 256) + /* complex */
BITAND(NVL(flag, 0), 4096) > 0 /* aggregate */
SELECT OWNER
, OWNERID
, NAME
, TABLE_NAME
, MASTER_VIEW
, MASTER_LINK
,
MTIME
, CAN_USE_LOG
, ERROR
, TYPE
, QUERY
, FLAG
, ROWID_SNAP
,
PRIMKEY_SNAP
, UPDATE_SNAP
, UPDATE_TRIG
, UPDATE_LOG
, MASTABS
,
MASVER
, LOB_VECTOR
, SNAPSHOT
, SNAPID
, INSTSITE
, FLAVOR_ID
,
3
, SQL_VER
FROM EXU9SNAP
WHERE BITAND(NVL(FLAG
, 0)
, 16) + /* SUPPORTED SNAPSHOTS: ROWID */
BITAND(NVL(FLAG
, 0)
, 32) + /* PRIMARY KEY */
BITAND(NVL(FLAG
, 0)
, 256) + /* COMPLEX */
BITAND(NVL(FLAG
, 0)
, 4096) > 0 /* AGGREGATE */
|
|
|