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|