Chapter 2

More “Beginning” SQL Commands

In this chapter, we start by expanding on the power of the SELECT command. Then we show you how to create tables, insert values into tables, change values in tables, and delete rows from tables. The next sections discuss the transaction processing commands ROLLBACK, COMMIT, and SAVEPOINT, which can be used in multi-user environments. Transaction processing commands can be used to undo changes in the database within a transaction. The chapter closes with a discussion of common data types available in Oracle, and includes an extended discussion of the DATE data type.

An Extended SELECT Statement

The SELECT is usually the first word in a SQL statement. The SELECT statement instructs the database engine to ...

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.