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