Chapter Contents

SAS/ACCESS Software for Relational Databases: Reference

ORACLE Naming Conventions

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 conventions:

A name must start with a letter. However, if the name appears within double quotation marks, it may start with any character.
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 sensitive.
A name cannot be an ORACLE reserved word.
A name cannot be the same name as another ORACLE object.

Chapter Contents
Previous
Next
Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.