Online Oracle-supplied eLearning - Training Resources

Oracle-Supplied Packages and DBMS_SCHEDULER To use Oracle-supplied packages  more...

Oracle9i Database Admin Create a Database ...efits of using stored program units, and the functions of Oracle-supplied packages. • Retrieve information about stored objects, identify the common situations when dependent objects may have an INVALID status, and the functions of the control file with the types of information stored. • Retrieve control file information, multiplex a control file, and identify the uses of redo log  more...

Oracle PL SQL Database Programming Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...

Oracle8i Performance Tuning Architecture Strategy Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,  more...

Oracle8i Database Admin Create Databases ...Identify the benefits of stored program units. Match the Oracle-supplied packages with their functions. Retrieve information about invalid objects in a specified database by querying the required data dictionary view. Retrieve information about a stored program unit specification by using the Oracle SQL*Plus Worksheet. Identify the common situations when dependent objects may have an  more...

Oracle8 Database Administration - Create Databases ...Identify the benefits of stored program units. Match the Oracle-supplied packages with their functions. Retrieve information about invalid objects in a specified database by querying the required data dictionary view. Retrieve information about a stored program unit specification by using the Oracle SQL Worksheet. Identify the common situations when dependent objects may have an invalid  more...

Oracle Database 10g PL SQL Fundamentals Part 1 In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as  more...

Oracle Database 10g PL SQL Fundamentals Part 2 ... Identify features of the PL/SQL wrapper utility. Match Oracle-supplied packages with their uses. Match procedures provided by the DBMS_OUTPUT package with their features. Identify features of the UTL_FILE package. Identify features of the HTP package. Identify the syntax for sending e-mail messages using the UTL_MAIL package. Match components of the DBMS_SCHEDULER package with  more...

Oracle Database 10g PL SQL Fundamentals Part 3 ...pendencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements with their descriptions. Identify features of dynamic SQL. Identify the features of the DBMS_SQL package. Identify guidelines for standardizing constants and  more...