oracle查詢庫中的視圖

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;