Oracle SQL: the Essential Reference

1.8. SQL Statements

There are a large number of SQL statements supported for Oracle and described in subsequent chapters of this book. As an aid to identifying the particular SQL statement you might need and helping you find it in the book, Table 1-5 presents a list of SQL commands in alphabetical order, along with a short description, and the chapter number and heading where you can find the full syntax and description of that statement.

Table 1-5. SQL Statements Covered in This Book

SQL Statement	Description	Found in Chapter	Under This Heading
ALTER CLUSTER	Redefines future storage allocations or allocates an extent for a cluster	Chapter 2	CREATE/ALTER/DROP CLUSTER
ALTER DATABASE	Changes one or more characteristics of an existing database	Chapter 2	CREATE/ALTER DATABASE
ALTER FUNCTION	Recompiles a stored PL/SQL function	Chapter 7	ALTER FUNCTION
ALTER INDEX	Changes the characteristics of an index	Chapter 2	CREATE/ALTER/DROP INDEX
ALTER MATERIALIZED VIEW	Changes the storage characteristics or automatic refresh characteristics of a materialized view or snapshot	Chapter 2	CREATE/ALTER/DROP MATERIALIZED VIEW
ALTER MATERIALIZED VIEW LOG	Changes the storage characteristics of a materialized view log	Chapter 2	CREATE/ALTER/DROP MATERIALIZED VIEW LOG
ALTER PACKAGE	Recompiles a PL/SQL package	Chapter 7	ALTER PACKAGE
ALTER PROCEDURE	Recompiles a PL/SQL stored procedure	Chapter 7	ALTER PROCEDURE
ALTER PROFILE	Adds, changes, or removes a resource limit from an existing profile	Chapter ...