 |
» |
|
|
|
Table of Contents - ENABLE AUDIT LOGGING
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- ENABLE RULES
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- END DECLARE SECTION
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- EXECUTE
- Scope
- SQL Syntax
- Parameters
- SQL Syntax — HostVariableSpecification
- Parameters — HostVariableSpecification
- Description
- Authorization
- Examples
- EXECUTE IMMEDIATE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- EXECUTE PROCEDURE
- Scope
- Syntax
- Parameters
- SQL Syntax—ActualParameter
- Parameters—ParameterDeclaration
- Description
- Authorization
- Examples
- FETCH
- Scope
- SQL Syntax
- Parameters
- SQL Syntax — BULK HostVariableSpecification
- Parameters — BULK HostVariableSpecification
- SQL Syntax — non-BULK HostVariableSpecification
- Parameters — non-BULK HostVariableSpecification
- Description
- Authorization
- Examples
- GENPLAN
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- GOTO
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- GRANT
- Scope
- SQL Syntax — Grant Table or View Authority
- Parameters — Grant Table or View Authority
- Authorization — Grant Table or View Authority
- SQL Syntax — Grant RUN or EXECUTE Authority
- Parameters — Grant RUN or EXECUTE Authority
- Authorization — Grant RUN or EXECUTE Authority
- SQL Syntax — Grant CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- Parameters — Grant CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- Description — Grant CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- Authorization — Grant CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- SQL Syntax — Grant DBEFileSet Authority
- Parameters — Grant DBEFileSet Authority
- Description
- Authorization — Grant DBEFilesSet Authority
- Examples
- IF
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- INCLUDE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- INSERT
- Scope
- SQL Syntax - Insert Rows with Defined Values
- Parameters - Insert Rows with Defined Values
- SQL Syntax — SingleRowValues
- Parameters — SingleRowValues
- SQL Syntax — LongColumnIOString
- Parameters — LongColumnIOString
- Description — LongColumnIOString
- SQL Syntax — BulkValues
- Parameters — BulkValues
- Description — Insert Rows with SingleRowValues
and BulkValues
- SQL Syntax — DynamicParameterValues
- Parameters — DynamicParameterValues
- Description — Insert Rows with DynamicParameterValues
- Authorization — Insert Rows with SingleRowValues
and Bulk Values
- SQL Syntax — INSERT Rows Defined by a SELECT
Command (Type 2 Insert)
- Parameters — INSERT Rows Defined by a SELECT
Command (Type 2 Insert)
- Description — INSERT Rows Defined by a SELECT
Command (Type 2 Insert)
- Authorization — INSERT Rows Defined by a
SELECT Command (Type 2 Insert)
- Examples
- Labeled Statement
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- LOCK TABLE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- LOG COMMENT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- OPEN
- Scope
- SQL Syntax
- Parameters
- Description
- PREPARE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- PRINT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- RAISE ERROR
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- REFETCH
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RELEASE
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- REMOVE DBEFILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- REMOVE FROM GROUP
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RENAME COLUMN
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RENAME TABLE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RESET
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RETURN
- Scope
- SQL Syntax
- Parameters
- Description
- Example
- REVOKE
- Scope
- SQL Syntax — Revoke Table or View Authority
- Parameters — Revoke Table or View Authority
- Description — Revoke Table or View Authority
- Authorization — Revoke Table or View Authority
- SQL Syntax — Revoke RUN or EXECUTE or Authority
- Parameters--Revoke RUN or EXECUTE Authority
- SQL Syntax — Revoke CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- Parameters — Revoke CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- Description — Revoke CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- Authorization — Revoke CONNECT, DBA, INSTALL,
MONITOR, or RESOURCE Authority
- SQL Syntax — Revoke DBEFileSet Authority
- Parameters — Revoke DBEFileSet Authority
- Description — Revoke DBEFileSet Authority
- Authorization — Revoke DBEFileSet Authority
- Examples
- ROLLBACK WORK
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
Chapter 10, 11 and 12 describe all the SQL statements in alphabetical
order, giving syntax, parameters, descriptions, authorization requirements,
and examples for each statement. Examples often consist of groups
of statements so you can see how each statement is related to other
statements functionally. |
