SQL语法参考

The SQL Syntax

Reference

T

his appendix describes the Oracle 8i SQL syntax, including

all main SQL statements and their clauses. The aim of this

appendix is to provide a concise and complete description of

the SQL syntax. Please refer to the other chapters in this book

for an explanation of the Oracle concepts and techniques.

table

view

* or column.

A

A

data_source clause separately.

You use ALTER RESOURCE COST to specify the parameters Oracle uses to calculate

the total resource cost for a session. Four parameters can be weighted into the

calculation. If a parameter is omitted, it won’t be taken into account at all. The

ALTER RESOURCE COST command’s syntax follows:

ALTER RESOURCE COST

{ CPU_PER_SESSION

command syntax:

You can use the ALTER SESSION command to change session options. Listing A-1

provides the syntax for the

| {ENABLE|DISABLE|FORCE} PARALLEL

{DML|DDL} [PARALLEL

integer

]

}

session_option :=

category_name

’}

| CURRENT_SCHEMA =

| GLOBAL_NAMES = {TRUE|FALSE}

| HASH_AREA_SIZE = integer

| HASH_JOIN_ENABLED = {TRUE|FALSE}

| HASH_MULTIBLOCK_IO_COUNT = integer

| INSTANCE = integer

| LOG_ARCHIVE_DEST_n =

{

null_string

| { LOCATION =

pathname

servicename

}

integer

| MAX_DUMP_FILE_SIZE = {

size

| NLS_CALENDAR = ‘text’

| NLS_COMP = ‘text’

| NLS_CURRENCY = ‘text’

| NLS_DATE_FORMAT = ‘format’

| NLS_DATE_LANGUAGE = language

| NLS_ISO_CURRENCY = ‘text’

| NLS_LANGUAGE = language

| NLS_NUMERIC_CHARACTERS = ‘text’

| OPTIMIZER_INDEX_CACHING =

| OPTIMIZER_INDEX_COST_ADJ =

| OPTIMIZER_MAX_PERMUTATIONS =

integer

| OPTIMIZER_SEARCH_LIMIT = integer

| PARALLEL_INSTANCE_GROUP = ‘text’