[Home] [Help]
VIEW: SYS._BASE_OPT_FINDING_OBJ_COL
Source
View Text - Preformatted
SELECT
f.f_id,
f.f_obj#,
f.obj_type,
f.notes,
c.column_value
FROM
sys."_BASE_OPT_FINDING_OBJ" f,
table(sys.dbms_spd_internal.get_vec_set_ids(f.col_list, f.cvec_size)) c
View Text - HTML Formatted
SELECT
F.F_ID
,
F.F_OBJ#
,
F.OBJ_TYPE
,
F.NOTES
,
C.COLUMN_VALUE
FROM
SYS."_BASE_OPT_FINDING_OBJ" F
,
TABLE(SYS.DBMS_SPD_INTERNAL.GET_VEC_SET_IDS(F.COL_LIST
, F.CVEC_SIZE)) C