Oracle9i PL/SQL Programming
From the authorized Oracle Press comes a complete guide to developing robust PL/SQL applications. The book contains new information on development tools, datatypes, SQL commands and functions, and much more. The CD-ROM contains sample code plus a sampling of development environments covered in the book.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Features of PLSQL
Conventions Used in This Book
80 other sections not shown
Other editions - View all
Available online BEGIN BINARY_INTEGER Boolean bytes call stack Chapter CHAR char_col character set classes clause column compiled CREATE OR REPLACE current user current_credits cursor variable data dictionary Data Dictionary View database triggers datatype DBMS DBMS_OUTPUT debugging declarative section default DELETE elements END LOOP exception handler executed fetch first_name following example function index-by tables INSERT INTO temp_table Java last_name library catalog materialized views nested table NULL NUMBER object types Oracle.9i Oracle7 Procedural Oracle8i output p_Course p_Department package body PL/SQL block PL/SQL engine PL/SQL procedure successfully positional notation pragma Procedural and SQL procedure successfully completed PUT_LINE query registered students REPLACE PACKAGE REPLACE PROCEDURE room_id ROWID rows runtime SAVEPOINT SELECT server specified sql CREATE sql DECLARE sql SQL SQL Statements Returns SQL*Plus stored procedure string student_id subprograms syntax TIMESTAMP transaction trigger UPDATE v_Count v_Counter v_Index v_Numbers v_Result v_Strings v_Student VARCHAR2 varray Version Available