Your shopping cart is empty.

Teach Yourself SQL/PL SQL using Oracle 8i & 9i with SQL J By Ivan Bayross

Rs. 405.00

Author: Ivan Bayross


  • Language: English
  • Binding: Paperback
  • Publisher: BPB Publications
  • ISBN: 9788176566919
  • Edition: 2003
  • Pages: 918
  • Dimension: 23.5 X 18.5 X 4 cm


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.

Table Of Contents:  

  1. Creating the SQL Framework 
  2. Setting Up Interactive SQL Plus Tool 
  3. Interactive SQL Part 1 
  4. Interactive SQL Part 2 
  5. Interactive SQL Part 3 
  6. Interactive SQL Part 4 
  7. SQL Performance Tuning 
  8. Security Management Using SQL  
  9. OOPS in Oracle 
  10. Introduction to PL/SQL 
  11. PL/SQL Transactions 
  12. PL/SQL security 
  13. PL/SQL Database Objects 
  14. Java in Oracle 
  15. An Introduction to SQLJ 
  16. Iterators and SQL Constructors in SQLJ 
  17. Oracle 9i NewFeatures