Oracle9i PL/SQL ProgrammingFrom 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.
Contents
Why PLSQL? | 4 |
Features of PLSQL | 7 |
Conventions Used in This Book | 14 |
Copyright | |
80 other sections not shown
Other editions - View all
Common terms and phrases
accessible actual parameter Available online BEGIN BINARY_INTEGER BOOLEAN bytes call stack Chapter CHAR char_col character set classes clause CLOB column compiled contains CREATE OR REPLACE current user current_credits cursor variable data dictionary views database table database triggers datatype DBMS_OUTPUT.PUT_LINE debugging declarative section default DELETE Description elements END LOOP exception handler executed fetch first_name following example following SQL*Plus session formal parameters function index-by tables INSERT INTO temp_table Java last_name materialized views nested table NULL NUMBER object types operation Oracle Database Oracle9 output p_Course p_Department p_StudentID package body PL/SQL block PL/SQL engine PL/SQL procedure successfully positional notation pragma privilege Procedural and SQL procedure successfully completed query raised RecordFullClasses REPLACE PACKAGE REPLACE PROCEDURE room_id ROWID rows runtime SAVEPOINT schema server specified SQL statements Returns stored procedure stored subprograms string syntax temp_table num_col TIMESTAMP transaction UPDATE v_Count v_Counter v_Index v_Result VARCHAR2 varray Version Available OracleS