.Net  

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;

  

posted on 2007-06-12 00:22 东方新秀 阅读(...) 评论(...) 编辑 收藏
 
Copyright © 东方新秀 Powered by: 博客园 模板提供:沪江博客