Hello,
I have 2 set returning functions:
select get_modeltablelist('foo') t
t
--
_emc_cubelist
_efm_modellist
_efm_sequences
select get_table_depends('cicpg_logs', '_efm_sequences') d
Typ Table Object
--- ----- -------
TR _efm_sequences _efm_sequences_tr
Now I want to combine both.
This is valid, but I can't find the syntax to get the results in multiple columns instaed of a singel 'record' column:
select get_table_depends('cicpg_logs', t) FROM get_modeltablelist('efeeds') t
get_table_depends
-----------------
(TR,_efm_sequences,_efm_sequences_tr)
(TR,_emr_reportlist,_emr_reportlist_tr)
(TR,_efm_models,_efm_models_del_tr)
regards,
Marc Mamin