Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL
This course is included in our On-demand training solution.
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL recognize the steps for overloading subprograms, using forward declarations, writing package initialization blocks, and maintaining persistent package state. identify the steps for using the Oracle-supplied packages DBMS_OUTPUT, UTL_FILE, and UTL_MAIL. recognize the steps for using Oracle-supplied packages to generate a simple Web page and schedule PL/SQL code for execution. identify the steps for constructing and executing SQL statements at run time, using Native Dynamic SQL (NDS) statements in PL/SQL. alter a package so that it contains overloaded subprograms, use an Oracle-supplied package, and execute dynamic SQL in a given scenario. identify the steps for designing packages so that code is easy to maintain, efficient, and readable, and so that PL/SQL applications perform better. identify the steps for binding whole arrays of values in a single operation, and for retrieving information about a row affected by a SQL operation.