Text

Oracle PL/SQL programming

---

Terdapat bibliografi dan indeks.

Table of Contents
Part I Programming in PL/SQL
Chapter 1 Introduction to PL/SQL
What Is PL/SQL?
The Origins of PL/SQL
So This Is PL/SQL
About PL/SQL Versions
Resources for PL/SQL Developers
Some Words of Advice
Chapter 2 Creating and Running PL/SQL Code
Navigating the Database
Creating and Editing Source Code
SQL*Plus
Performing Essential PL/SQL Tasks
Editing Environments for PL/SQL
Calling PL/SQL from Other Languages
Chapter 3 Language Fundamentals
PL/SQL Block Structure
The PL/SQL Character Set
Identifiers
Literals
The Semicolon Delimiter
Comments
The PRAGMA Keyword
Labels

Part II PL/SQL Program Structure
Chapter 4 Conditional and Sequential Control
IF Statements
CASE Statements and Expressions
The GOTO Statement
The NULL Statement
Chapter 5 Iterative Processing with Loops
Loop Basics
The Simple Loop
The WHILE Loop
The Numeric FOR Loop
The Cursor FOR Loop
Loop Labels
The CONTINUE Statement
Tips for Iterative Processing
Chapter 6 Exception Handlers
Exception-Handling Concepts and Terminology
Defining Exceptions
Raising Exceptions
Handling Exceptions
Building an Effective Error Management Architecture
Making the Most of PL/SQL Error Management

Part III PL/SQL Program Data
Chapter 7 Working with Program Data
Naming Your Program Data
Overview of PL/SQL Datatypes
Declaring Program Data
Programmer-Defined Subtypes
Conversion Between Datatypes
Chapter 8 Strings
String Datatypes
Working with Strings
String Function Quick Reference
Chapter 9 Numbers
Numeric Datatypes
Number Conversions
Numeric Operators
Numeric Functions
Chapter 10 Dates and Timestamps
Datetime Datatypes
Getting the Current Date and Time
Interval Datatypes
Datetime Conversions
Date and Timestamp Literals
Interval Conversions
Interval Literals
CAST and EXTRACT
Datetime Arithmetic
Date/Time Function Quick Reference
Chapter 11 Records
Records in PL/SQL
Chapter 12 Collections
Collections Overview
Collection Methods (Built-ins)
Working with Collections
Nested Table Multiset Operations
Maintaining Schema-Level Collections
Chapter 13 Miscellaneous Datatypes
The BOOLEAN Datatype
The RAW Datatype
The UROWID and ROWID Datatypes
The LOB Datatypes
Working with LOBs
Predefined Object Types

Part IV SQL in PL/SQL
Chapter 14 DML and Transaction Management
DML in PL/SQL
Transaction Management
Autonomous Transactions
Chapter 15 Data Retrieval
Cursor Basics
Working with Implicit Cursors
Working with Explicit Cursors
SELECT...FOR UPDATE
Cursor Variables and REF CURSORs
Cursor Expressions
Chapter 16 Dynamic SQL and Dynamic PL/SQL
NDS Statements
Binding Variables
Working with Objects and Collections
Dynamic PL/SQL
Recommendations for NDS
When to Use DBMS_SQL
Oracle Database 11g New Features

Part V PL/SQL Application Construction
Chapter 17 Procedures, Functions, and Parameters
Modular Code
Procedures
Functions
Parameters
Local or Nested Modules
Module Overloading
Forward Declarations
Advanced Topics
Go Forth and Modularize!
Chapter 18 Packages
Why Packages?
Rules for Building Packages
Rules for Calling Packaged Elements
Working with Package Data
When to Use Packages
Packages and Object Types
Chapter 19 Triggers
DML Triggers
DDL Triggers
Database Event Triggers
INSTEAD OF Triggers
AFTER SUSPEND Triggers
Maintaining Triggers
Chapter 20 Managing PL/SQL Code
Managing Code in the Database
Managing Dependencies and Recompiling Code
Compile-Time Warnings
Testing PL/SQL Programs
Tracing PL/SQL Execution
Debugging PL/SQL Programs
Protecting Stored Code
Introduction to Edition-Based Redefinition (Oracle Database 11g Release 2)
Chapter 21 Optimizing PL/SQL Performance
Tools to Assist in Optimization
The Optimizing Compiler
Data Caching Techniques
Bulk Processing for Multirow SQL
Improving Performance With Pipelined Table Functions
Specialized Optimization Techniques
Stepping Back for the Big Picture on Performance
Chapter 22 I/O and PL/SQL
Displaying Information
Reading and Writing Files
Sending Email
Working with Web-Based Data (HTTP)
Other Types of I/O Available in PL/SQL

Part VI Advanced PL/SQL Topics
Chapter 23 Application Security and PL/SQL
Security Overview
Encryption
Row-Level Security
Application Contexts
Fine-Grained Auditing
Chapter 24 PL/SQL Architecture
Who (or What) is DIANA?
How Does Oracle Execute PL/SQL Code?
The Default Packages of PL/SQL
Execution Authority Models
Conditional Compilation
PL/SQL and Database Instance Memory
Native Compilation
What You Need to Know
Chapter 25 Globalization and Localization in PL/SQL
Overview and Terminology
Unicode Primer
Character Semantics
String Sort Order
Multilingual Information Retrieval
Date/Time
Currency Conversion
Globalization Development Kit for PL/SQL
Chapter 26 Object-Oriented Aspects of PL/SQL
Introduction to Oracle’s Object Features
Object Types by Example
Object Views
Maintaining Object Types and Object Views
Concluding Thoughts from a (Mostly) Relational Developer
Chapter 27 Calling Java from PL/SQL
Oracle and Java
Getting Ready to Use Java in Oracle
A Simple Demonstration
Using loadjava
Using dropjava
Managing Java in the Database
Using DBMS_JAVA
Publishing and Using Java in PL/SQL
Chapter 28 External Procedures
Introduction to External Procedures
The Oracle Net Configuration
Setting Up Multithreaded Mode
Creating an Oracle Library
Writing the Call Specification
Raising an Exception from the Called C Program
Nondefault Agents
Maintaining External Procedures

---

Availability

Detail Information

Series Title

--

Call Number

005.74 FEU o

Publisher

California : O'Reilly Media., 2009

Collation

xxxviii, 1186 hal.; ilus.; 24 cm

Language

English

ISBN/ISSN

9780596514464

Classification

005.74

Content Type

-

Media Type

-

Carrier Type

-

Edition

Fifth edition

Subject(s)

Database management
Oracle (Computer file)
SQL (Computer program language)

Specific Detail Info

--

Statement of Responsibility

Steven Feuerstein and Bill Pribyl

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment