Identifiers are names that uniquely identify metadata objects. The naming conventions follow standard Oracle naming rules. All identifiers are case-insensitive.
owner.{ cube | dimension | table }.{ measure | column }
| Convention | Quoted ID | Unquoted ID |
|---|---|---|
| Initial Character |
Any character. | Alphabetic character from the database character set. |
| Other Characters |
All characters, punctuation marks, and spaces are permitted.
Double quotation marks and nulls (\0) are not permitted. |
Alphanumeric characters from the database character set and underscore (_) are permitted.
The dollar sign ($) and pound sign (#) are permitted but not recommended.
Double quotation marks and nulls (\0) are not permitted. |
| Reserved Words | Permitted but not recommended. | Not permitted. |
SH.SALES_CUBE.QUANTITY_SOLD identifies a measure named Quantity Sold in the Sales cube in the SH schema.
Copyright © 2003, 2007, Oracle. All rights reserved.