Developing Personal Oracle7 for Windows 95 Applications

Overview

Introduction

Part I Getting Started with Personal Oracle7 for Windows 95

1 What Is Personal Oracle for Windows

2 Installing and Using Personal Oracle7

3 Personal Oracle7 for Windows 95: Database Administration Tools

4 Personal Oracle7 for Windows 3.11: Database Administration Tools

5 Your First Personal Oracle Database

Part II Using Personal Oracle7

6 The Basics of SQL

7 Accessing Personal Oracle7 with SQL*Plus

8 Creating and Modifying Tables

9 Using SQL to Modify Data

10 The Oracle Datatypes

11 Manipulating Strings

12 Dealing with Dates

13 Handling Numbers

14 Defining Table and Column Constraints

15 More Sophisticated Queries

16 Views, Sequences, and Synonyms

17 Defining Transactions

18 The Basics of PL/SQL

19 Creating and Using Stored Procedures, Functions, and Packages

20 PL/SQL Datatypes and Variables

21 Handling Errors and Exceptions in PL/SQL

22 Retrieving Data with Cursors

23 Enforcing Business Rules with Database Triggers

24 Saving and Loading Data

25 Database Backup and Recovery

26 Managing Space

27 Managing Users and Roles

Part III Moving from Desktop to Client/Server Environment

28 From There to Here: Database Migration

29 Upsizing Consideration

30 Distributed Database Features of Personal Oracle7 for Windows 95

31 Using Oracle PowerBrowser to Web-Enable Personal Oracle7

32 Performance Considerations

33 Oracle Internals

34 Troubleshooting

Appendixes

A Glossary

B Using Personal Oracle7 and Oracle Developer/2000

C Using Personal Oracle7 and PowerBuilder 5.0

D Using Personal Oracle7 and Visual Basic

E Using Personal Oracle7 and Oracle Power Objects