In Oracleprocedure, if you doesn\'t having any debugging tools like sql developer. It is very difficult to trace yourprocedurewhether is working properly or not. For me, I will using the DBMS_OUTPUT.PUTLINE command&sqlplusinto the ...
SHO[W] option where option represents one of the following terms or clauses: system_variable. ALL BTI[TLE] ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY| TRIGGER|VIEW|TYPE|TYPE BODY} [schema.]name] LNO PARAMETERS [parameter_name] ...
UKJA@ukja102>exec proc1; ^C C:\Documents and Settings\exem>sqlplusukja/ukja@ukja102 -- Session #2 -- Okay, now the session #1 got killed. -- But how about theprocedureitself? Is it terminated or alive? SYS@ukja10>@lock_internal 144 ...
sqlplushr/hr. SQL>create materialized view vv as select department_id,count(*),sum(salary),avg(salary),max(salary) from employees group by department_id;. Materialized view created. Let us check whether MV can be used by optimizer to enhance....PL/SQLproceduresuccessfully completed. SQL>conn / as sysdba. Connected. SQL>grant advisor to hr;. Grant succeeded. SQL>conn hr/hr. Connected. SQL>exec DBMS_ADVISOR.TUNE_MVIEW ( :v1,\'create materialized view mym as select ...
關於sqlplus procedure呢類問題研究 - 
其他相關話題
大家嘅答案
