Teach Yourself Sql & Pl/sql Using Oracle 8i & 9i With Sqlj

Description   The book has been written to provide an excellent grounding to those who wish to learn SQL, PL/SQL and SQLJ using Oracle 8i or 9i. Like all his earlier books this book also has several illustrative examples, which have a logical link between them. Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using the natural language of Oracle 8i or 9i has been established. Each topic is very liberally sprinkled with examples that are mapped to applications, which fit in the real world. If a grounding in Java is required a study of 'Web Enabled Commercial Application Development Using Java 2.0' written by Ivan Bayross is recommended. Contents - Creating the SQL Framework - Setting Up Interactive SQL Plus Tool - interactive SQL Part 1 - Interactive SQL Part 2 - Interactive SQL Part 3 - Interactive SQL Part 4 - SQL Performance Tuning - Security Management Using SQL - Loops in Oracle - Introduction to PL/SQL - PL/SQL Transactions - pl/sql security - PL/SQL Database Objects - Java in Oracle - An Introduction to SQLJ - Iterators and SQL Constructors in SQLJ - Oracle 9i New-Features