UPPERCASE | Uppercase text is used to call attention to command keywords, as well as database objects such as tables and stored procedures, procedure parameters, and so on. For example: |
If you create a private rollback segment, the name of the rollback segment must be included in the ROLLBACK_SEGMENTS parameter of the parameter file. | |
Italics | Italicized words within text are used to indicate the first occurrence and definition of a term, as in the following example: |
A database is a collection of data to be treated as a unit. The general purpose of a database is to store and retrieve related information, as needed. | |
Italicized words are also used for book titles and filenames. | |
Bold | Bold text is used to call special attention to important information. For example: |
In summary, remember that this procedure provides a reasonable estimate of a table's size, not an exact number of blocks or bytes. | |
ALTER TABLESPACE users ADD DATAFILE 'users2.ora' SIZE 50K;
Punctuation | Example statements can include punctuation such as commas or quotation marks. All punctuation given in example statements is required. Depending on the application being used, a semicolon or other terminator might be required to end a statement. |
UPPERCASE | Uppercase words in example statements are used to indicate the keywords within Oracle SQL. For example, keywords such as SELECT or INSERT in SQL statements are uppercase in command examples, as well as in running text. However, when issuing SQL statements, you can use upper or lower case. |
Lowercase | Lowercase words in example statements are used to indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file. |
Unless enclosed in double quotes ("), Oracle converts the names of objects such as tables and column names to uppercase. Some operating systems are case sensitive, so refer to your operating system-specific documentation to determine whether you must pay attention to case for filenames and other operating system- or language-specific objects. | |