Online Oracle-supplied eLearning Training

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...

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 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...