Estudiante

Introduction

Copyright © 2004, Oracle. All rights reserved.

Objectives

After completing this lesson, you should be able to do the following: • Describe the objectives of the course •Describe the course agenda • Identify the database tables used in the course • Identify the Oracle products that help you design a complete business solution

I-2

Copyright © 2004, Oracle. All rightsreserved.

Course Objectives

After completing this course, you should be able to do the following: • Appreciate that PL/SQL provides programming extensions to SQL • Write PL/SQL code to interfacewith the database • Design PL/SQL program units that execute efficiently • Use PL/SQL programming constructs and conditional control statements • Handle run-time errors • Describe stored proceduresand functions

I-3

Copyright © 2004, Oracle. All rights reserved.

Course Agenda

Lessons that are to be covered on day 1: I. Introduction 1. Introduction to PL/SQL 2. Declaring PL/SQLVariables 3. Creating the Executable Section 4. Interacting with the Oracle Database Server 5. Writing Control Structures

I-4

Copyright © 2004, Oracle. All rights reserved.

Course AgendaLessons that are to be covered on day 2: 6. Working with Composite Data Types 7. Using Explicit Cursors 8. Including Exception Handling 9. Creating Stored Procedures and Functions

I-5

Copyright ©2004, Oracle. All rights reserved.

The Human Resources (hr) Data Set

I-6

Copyright © 2004, Oracle. All rights reserved.

The Human Resources (hr) Data Set

I-7

Copyright © 2004, Oracle.All rights reserved.

Oracle10g

I-8

Copyright © 2004, Oracle. All rights reserved.

Oracle Database 10g
Object Relational Data

Documents

Multimedia

Messages

I-9

Copyright ©2004, Oracle. All rights reserved.

Oracle Application Server 10g
Portals

Transactional Apps

Business intelligence

Integration

Application development framework

Application...