摘要：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 阅读全文

摘要：ObjectivesAfter completing this lesson,you should be able to do the following:Identify lexical units in a PL/SQL block.Use build-in SQL functions in PL/SQLDescribe when implict conversions take place and when explict conversion have to be dealt withWrite nested blocks and qualify variables with labe 阅读全文

摘要：Types of VariablesGuidelines for Declaring and Inititalizing PL/SQL VariablesFollow naming conventions.Use meaningful identifiers for variables.Initialize variables designated as NOT NULL and CONSTANT.Initialize variables with the assignment operator (:=) or the DEFAULT keyword:v_myName VARCHAR2(20) 阅读全文

摘要：ObjectivesAfter completing this lesson,you should be able to do the followingRecognize valid and invalid identifies.List the uses of variables.Declare and initialize variables.List and descible various data types.Indentify the benefits of using the %TYPE attribute.Declare,useand print bind variables 阅读全文

摘要：ObjectivesAfter completing this lesson,you should be able to do the following:Explain the need for PL/SQLExplain the benefits of PL/SQLIndentify the different types of PL/SQL blocksOut messages in PL/SQLAbout PL/SQLStands for "Procedural Language extension to SQL".Is Oracle Corporation`s s 阅读全文

摘要：OjbectivesAfter completing this lesson,you should be able to do the following:Describle the course organizationDescrible the sample HR schemaCourse ObjectivesAfter completing this lesson,you should be able to do the following:Identify the programming extensions that PL/SQL provdies to SQL.Write PL/S 阅读全文