O'Reilly logo

Oracle SQL: the Essential Reference by David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required