|SAS/ACCESS Software for Relational Databases: Reference
ORACLE objects that may be named include tables, views,
columns, and indexes. For the ORACLE7 Server, objects also include database
triggers, procedures, and stored functions. Use the following ORACLE naming
- A name must start with a letter.
However, if the name appears within double quotation marks, it may start with
- A name must be from 1 to 30
characters long, except for database names, which are limited to 8 characters,
and link names, which are limited to 128 characters.
- A name may contain the letters
A through Z, the digits 0 through 9, the underscore (_), $, and #. If the
name appears within double quotation marks, it may contain any characters,
except double quotation marks.
- A name is not case sensitive.
For example, CUSTOMER is the same as customer. If, however, the name of the
object appears within double quotation marks when it is used, then it is case
- A name cannot be an ORACLE
- A name cannot be the same
name as another ORACLE object in the same schema.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.