2.2. Connecting

To proceed from this point forward, you need an Oracle database. There are two basic configurations. One software configuration is to have everything on one machine; that is, the Oracle database and client code can all be on your desktop. An alternative is for your Oracle database to be on a separate host, in which case you're connecting with SQL*Plus to Oracle over a network.

If your Oracle software environment is set up, you're ready to connect and begin executing SQL. If this needs to be done you can begin with installing the Oracle Client CD. This installs SQL*Plus and other utilities on your desktop that allow you to interact with a database on the network. An alternate is to install the Oracle Enterprise CD. This gives you ...

Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.