oracle查看视图引用表及视图内容

1.查看存储过程引用了哪些表和视图

select *
from dba_dependencies
where referenced_name = xxx
and referenced_type in ('TABLE','VIEW');

2.查看存储过程内内容

select name,line,text
from user_source
where name=xxx
order by line;