Visual Basic Oracle 8

Book Overview

This book provides a concise and yet comprehensive guide to accessing Oracle databases with Visual Basic. You'll quickly learn how to use ActiveX Data Objects (ADO) and Oracle Objects For OLE (OO4O) in an object oriented VB program. You'll also learn PL/SQL - the language of stored procedures and triggers, and see how to pass parameters to or return result sets from stored procedures. Throughout the book we combine theory and hands on practice. You'll build an application which shows how to guarantee data integrity with OO4O and ADO, using transaction control and stored procedures.

What is Great About this Book

• Fills a gap in the market for Oracle Database Access from VB.
  
• Provides timely information on both Oracle and Microsoft technologies (OO4O and ADO).
  
• Combines theory, reference and practice, including an example application.
  
• Acts as a vital reference on syntax and semantics for working with Oracle databases from VB.

Who is this Book for?

This book assumes that the reader is familiar with Visual Basic and can develop simple applications. No prior knowledge of Oracle is required, although basic familiarity with any relational database is an advantage. This book is for those who wish to take Visual Basic past the beginning stage and into more complex database development with Oracle as the database server. While the focus will be on Oracle, many of the topics that are covered will be applicable to all database systems, especially server-based databases.

Table of contents

Introduction
Section I - The Fundamentals - an Overview of Oracle, VB, SQL and Data Access
Chapter 1: Introducing Oracle and VB
Chapter 2: Queries and Data Manipulation Using SQL
Chapter 3: Creating and Managing Database Tables
Chapter 4: Object Oriented Programming, Data Classes and Data Access Technologies
Section II - Using OO4O and Oracle
Chapter 5: An OO4O Application
Chapter 6: Using Parameters with OO4O
Chapter 7: Optimizing the OO4O Connection and Data Classes
Chapter 8: Oracle Objects For OLE Reference
Section III - Using ADO and Oracle
Chapter 9: An ADO Application
Chapter 10: Using Parameters with ADO
Chapter 11: Optimizing the ADO Connection and Data Classes
Chapter 12: An ADO Reference
Section IV - PL/SQL, Stored Procedures and Transactions
Chapter 13: PL/SQL, Stored Procedures and Triggers
Chapter 14: A Practical Application Using Transactions and Stored Procedures
Section V - Moving on up - N-Tier Solutions
Chapter 15: COM and Middle-Tier Business Objects
Chapter 16: COM and Middle Tier Data Objects
Chapter 17: Hosting COM Components on MTS
Section VI - Appendecies
Appendix A: ADO Object Summary
Appendix B: Connecting to Oracle via Access
Appendix C: Oracle URLs and Books
Appendix D: Data Dictionary Tables
Appendix E: HR Application Class Listings
Appendix F: Support and Errata