Chapter 1

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. ...

Get Practical Guide to using SQL in Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.