ch10 - P L / S Q L Oracle10g Developer: PL/SQL Programming...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
P L / S Q L Oracle10 g Developer: PL/SQL Programming Chapter 10 Oracle-Supplied Packages and SQL*Loader
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10g Developer: PL/SQL Programming 2 Objectives After completing this lesson, you should be able to understand: Using communications packages Generating output via packages Including large objects in the Oracle database Exploring dynamic SQL and PL/SQL Identifying other important built-in packages Using the SQL*Loader utility
Background image of page 2
P L / S Q L Introduction Oracle provides build-in feature to address many commonly needed operations PL/SQL users should be familiar with the many complete packages Called Oracle-supplied or built-in packages Extending the functionality of PL/SQL and SQL Loader utility. Oracle10g Developer: PL/SQL Programming 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Introduction Each Oracle-supplied package comes with parameters. It is helpful to review the individual scripts Located in rdbms\admin directory Each scripts contains comments documenting the code. The SQL*Loader utility enables loading data in almost any format into an Oracle database. Oracle10g Developer: PL/SQL Programming 4
Background image of page 4
P L / S Q L Rebuild database Load and run “c10Dbcreate.sql” Oracle10g Developer: PL/SQL Programming 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10g Developer: PL/SQL Programming 6 Communications Packages Built-in Package Name Description Script Filename DBMS_PIPE Allows different database sessions to communicate dbmspipe.sql DBMS_ALERT Enables notification of database events dbmsalrt.sql UTL_SMTP Enables e-mail features utlsmtp.sql
Background image of page 6
P L / S Q L Oracle10g Developer: PL/SQL Programming 7 DBMS_PIPE Allows different sessions in the same instance to communicate When the Oracle database is started, a SGA (system global area) or memory buffers are allocated and background process are started; they make up an Oracle instance Oracle pipes are mechanism sending information using buffers in the SGA; lost when instance is shut down. Typically used to interface with the operating system or an external system Sending a message is a two-step process of packing and sending
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10g Developer: PL/SQL Programming 8 DBMS_PIPE Example
Background image of page 8
P L / S Q L Oracle10g Developer: PL/SQL Programming 9 DBMS_ALERT Allows real-time messages or alerts to be sent to users upon a particular event Accomplished in a database trigger to be associated with an event An example use is online auctions Process includes: register an alert name, set when alert should signal, and identify users that should be recipients
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10g Developer: PL/SQL Programming 10 DBMS_ALERT Example Register name DBMS_ALERT.REGISTER(‘new_bid’);
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/17/2012 for the course GCIS 511 taught by Professor Liu during the Fall '10 term at Gannon.

Page1 / 40

ch10 - P L / S Q L Oracle10g Developer: PL/SQL Programming...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online