View to view View Source

[martindsouza]

See http://dickdral.blogspot.ca/2016/05/query-view-sources-like-you-query-your.html?m=1 as an example.

Need to think of simple way to do this. Avoiding schema level types would be preferred.

[antonscheffer]

You could use something like: `` create or replace package as_source is subtype tp_all_source_row is sys.all_source%rowtype; type tp_all_source_tab is table of tp_all_source_row; function get_source ( object_name varchar2 , object_type varchar2 := 'ALL' , owner varchar2 := null ) return tp_all_source_tab pipelined; end; /