SQL Statement

Function

specifies any SQL statement.

Format

<sql statement> ::=

<create table statement>

| <drop table statement>

| <alter table statement>

| <create synonym statement>

| <drop synonym statement>

| <create snapshot statement>

| <drop snapshot statement>

| <create snapshot log statement>

| <drop snapshot log statement>

| <create view statement>

| <drop view statement>

| <create index statement>

| <drop index statement>

| <create sequence statement>

| <drop sequence statement>

| <oracle ddl statement>

| <comment statement>

| <create user statement>

| <drop user statement>

| <grant statement>

| <revoke statement>

| <insert statement>

| <update statement>

| <delete statement>

| <truncate statement>

| <query statement>

| <open cursor statement>

| <fetch statement>

| <close statement>

| <single select statement>

| <connect statement>

| <commit statement>

| <rollback statement>

| <rollback to statement>

| <savepoint statement>

| <lock statement>

| <release statement>

Syntax Rules

none

General Rules

1. The SQL statements of the 1st block are described in the chapter 'Data Definition'.

2. The SQL statements of the 2nd block are described in the chapter 'Authorization'.

3. The SQL statements of the 3rd block are described in the chapter 'Data Manipulation'.

4. The SQL statements of the 4th block are described in the chapter 'Data Retrieval'.

5. The SQL statements of the 5th block are described in the chapter 'Transactions'.

6. All SQL statements can be embedded in programming languages. For a detailed description, refer to the manuals on the precompilers.