Chapter 7. Managing Data With SQL, PL/SQL, and Utilities
ORACLE DATABASE 10 G: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Managing Data
Manipulate data through SQL using INSERT, UPDATE, and DELETE.
Use Data Pump to export data.
Use Data Pump to import data.
Load Data with SQL Loader.
Create directory objects.
PL/SQL
Identify PL/SQL objects.
Describe triggers and triggering events.
Identify configuration options that affect PL/SQL performance.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
Oracle supports manipulating data via several interfaces, but the most common are SQL and PL/SQL. Understanding how to use and manage PL/SQL programs is an important skill for any DBA. Some database functionality is delivered only as PL/SQL programs, such as fine-grained auditing, and some functionality is available in both a command-line version or as PL/SQL programs, such as Data Pump export and Data Pump import. As you gain experience, you will increasingly rely on using PL/SQL to manage your databases. So you need to have a solid grasp of SQL and PL/SQL fundamentals to be a successful Oracle10g DBA.
In this chapter, you will learn how to create, change, and remove information from an Oracle database using SQL and PL/SQL.