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