Getting Started with Oracle
In this chapter, we will cover some elementary commands and statements that will allow us to use Structured Query Language (SQL). We will see generic operations that we can do with SQL and specific statements that pertain to the principal delivery system, Oracle. We will be concentrating on SQL*PLUS (often written as SQLPLUS and henceforth referred to as SQLPLUS), which is used to generate, store, and edit SQL queries and to control the database environment.
We start the chapter by showing you how to get started with Oracle in UNIX. Basic familiarity with the UNIX operating system is assumed. Then we present some basic system parameters, before introducing you to Oracle's commands — mainly the SELECT syntax. ...