A user-supplied value is any text value, except an entity-occurrence name, that you supply in a DDL statement. For example, your user ID and password are user-supplied values. So are character-string literals used in Boolean expressions and descriptive text for schema and subschema entities.
Lowercase letters are retained in user-supplied values which are enclosed in quotes (such as comments). In values not enclosed in quotes, lowercase letters are translated to uppercase.
The coding rules listed for entity-occurrence names apply to user-supplied values. In addition, you can use quotation marks in order to use special characters. The DDL compilers treat these characters as special characters :
The single quotation mark (') is the default quote character established during installation. You can specify the double quotation mark (") as the quote character by means of the SET OPTIONS statement.
Embedding the Quote Character
When the quote character is to be embedded in a user-supplied name, it must appear twice for each occurrence in the original name. For example, the name MARY'S PROGRAM should be input as 'MARY''S PROGRAM' if the single quotation mark (') has been designated as the quote character, and as "MARY'S PROGRAM" if the double quotation mark (") has been designated as the quote character.
Code the Closing Quote
If the closing quote is omitted from a quoted literal, the literal is interpreted as including everything to the end of the input column range.
Nullifying Existing Values
Two quote characters with no space between them is a null string. Null strings can be used for nulling out existing values. Note that the null string does not null lines of comment text in COMMENTS clauses; it creates one blank line.
|
Copyright © 2014 CA.
All rights reserved.
|
|