All names used within ACCENT R that refer to Oracle data such as Oracle Server (database) names, table names, and column names must obey Oracle's naming convention which is as shown below:
- Must be 30 characters or less
- First character must be alphabetic
- Characters that come after the first character can include letters, digits, or '_'
- Embedded spaces are not allowed
- Special characters are not allowed
|
Valid
|
Invalid
|
|
PUBLISHER_CODE
|
name#123
|
|
Publisher_Id
|
name has blanks
|
|
AccentR
|
thisnameistoolongforidentifiers
|
|
AFDIV123_SHIFT
|
publisher.id
|
Figure 11 Example of Valid and Invalid Names