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,
rscn, objflag, flag2, status, sna_type_owner, sna_type_name,
parent_sowner, parent_vname,
8, sql_ver, alias_txt, mview_comment, syn_count
FROM exu11snap
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
,
RSCN
, OBJFLAG
, FLAG2
, STATUS
, SNA_TYPE_OWNER
, SNA_TYPE_NAME
,
PARENT_SOWNER
, PARENT_VNAME
,
8
, SQL_VER
, ALIAS_TXT
, MVIEW_COMMENT
, SYN_COUNT
FROM EXU11SNAP
|
|
|