SQL*Plus Quick Reference
Release 8.1.5

A66735-01

Library

Product

Prev Up Next

SQL*Plus Quick Reference, 2 of 10


Conventions for Command Syntax

The following two tables describe the notation and conventions for command syntax used in this Quick Reference.

Commands, Terms, and Clauses

Feature  Example  Explanation 

uppercase 

BTITLE
 

Enter text exactly as spelled; it need not be in uppercase. 

lowercase italics 

column
 

A clause value; substitute an appropriate value. 

words with specific meanings 

c
 

A single character. 

 

char
 

A CHAR value--a literal in single quotes--or an expression with a CHAR value. 

 

d or e
 

A date or an expression with a DATE value. 

 

expr
 

An unspecified expression. 

 

m or n
 

A number of an expression with a NUMBER value. 

 

text
 

A CHAR constant with or without single quotes. 

 

variable
 

A user variable (unless the text specifies another variable type). 

Other words are explained where used if their meaning is not explained by context.

Punctuation

Feature  Example  Explanation 

vertical bar 

|
 

Separates alternative syntax elements that may be optional or mandatory. 

brackets 

[OFF|ON]
 

One or more optional items. If two items appear separated by |, enter one of the items. Do not enter the brackets or |. 

braces 

{OFF|ON}
 

A choice of mandatory items; enter one of the items. Do not enter the braces or |. 

underlining 

{OFF|ON}
 

A default value; if you enter nothing, SQL*Plus assumes the underlined value. 

ellipsis 

n ...
 

Preceding item(s) may be repeated any number of times. 

Enter other punctuation marks (such as parentheses) where shown in the command syntax.


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product