Oracle9i Instant PL/SQL Scripts

Oracle9i Instant PL/SQL Scripts

4.11 - 1251 ratings - Source

This text provides readers with a comprehensive collection of SQL and PL/SQL scripts. It is organized into chapters by function and each script is fully documented with sample results shown. Readers can understand how the script works, learn to customize the script with confidence, and act properly on the script's results. Features include: scripts specifically for Oracle9i; a CD-ROM including major scripts from book; CD-icon with script name next to scripts that appear on the CD to allow for a quick search; a list of scripts and a brief description at the beginning of each chapter; and Programmer's Notes and Annotations that provide expert explanations on the scripts and how they can be customized.As of Oracle8, you can create abstract datatypes and use them as if they were Oracle- type.sql provided datatypes such as NUMBER and VARCHAR2. ... PRAGMA RESTRICT_REFERENCES(AGE, WNDS)); In this example, the ANIMAL_TY datatype has three attributes: Breed, ... method called AGE: member function AGE (BirthDate IN DATE) return NUMBER, PRAGMA RESTRICT REFERENCES (AGE, anbsp;...

Title:Oracle9i Instant PL/SQL Scripts
Author:Kevin Loney, Meghraj Thakkar, Rachel Carmichael
Publisher:McGraw-Hill Osborne Media - 2001


You Must CONTINUE and create a free account to access unlimited downloads & streaming