摘要：
Exceptions Not HandledCalling PathSome Procedures Demo可参考脚本:192.168.1.200[oracle@DG1 scripts]$ pwd/u01/oracle/scripts[oracle@DG1 scripts]$ lltotal 60-rw-r--r-- 1 oracle oinstall 886 Apr 19 15:35 call_calculate_blance.sql-rw-r--r-- 1 oracle oinstall 220 Apr 19 14:26 s09_01.sql-rw-r--r-- 1 oracle oins 阅读全文
摘要：
Passing Actula Parameters:Creating the add_dept ProcedureView Code CREATE OR REPLACE PROCEDURE add_dept( p_name IN dept.department_name%TYPE, p_loc IN dept.location_id%TYPE)ISBEGIN INSERT INTO dept(department_id,department_name,location_id) VALUES(departments_seq.NEXTVAL... 阅读全文
摘要：
Using the IN、OUT、IN OUTParameter Mode:ExampleDemo 01:IN KeywordsCREATE OR REPLACE PROCEDURE raise_salary( p_id IN emp.employee_id%TYPE, p_percent IN NUMBER)ISBEGIN UPDATE emp SET salary = salary * (1 + p_percent/100) WHERE employee_id = p_id;END ra... 阅读全文
摘要：
What Are Procedures?Are a type of subprogram that perform an actionCan be stored in the database as a schema object.Promote reusability and maintainabilityCreating Procedures:OverviewCreating Procedures with the SQL CREATE OR REPLACE StatementUse the CREATE clause to create a stand-alone procedure t 阅读全文
摘要：
ObjectivesAfter competing this lesson,you should be able to do the following:Identify the benefits of modualarized and layered subprogram design.Create and call procedures.Use formal and actual parametersUse positional,named ,or mixed notation for passing parameters.Identify the available parameter- 阅读全文
摘要：
placeholder 阅读全文