select *From dba_views;
select *From user_views;
desc dba_source;desc user_source;
select text from user_source
where name = 'Your pkg name'
order by line;
union可以去除重复记录,而union all则不行.
在oracle中如何调用存储过程?最好有具体代码示例!
直接调用过程名就可以了
如p_test1调用p_test2(asRet2 out varchar2)
create or replace procedure p_test1 (
asTest in varchar2,
asRet out varchar2 )
as
asProcRet varchar2(100);
...
begin
p_test2(asProcRet);
end p_test1;
写个plsql块在sqlplus中执行即可
begin
declare
asParam varchar2(10);
begin
p_test1(asParam);
end;
end;