Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Database design issues : Naming conventions : Field and column names
 
Field and column names
These are the restrictions for naming OpenEdge fields and Oracle columns:
*OpenEdge — Field names can be up to 32 characters long and can consist of alphabetic characters (A-Z and a-z), digits (0-9), and the special characters $, &, #, %, -, and _. A field name must begin with an alphabetic character.
*Oracle — Column names can be up to 30 characters long. They can consist of the same characters as OpenEdge names, except % and -.
The set of characters that OpenEdge allows includes all of the characters Oracle allows. The OpenEdge DB-to-Oracle utility replaces characters that Oracle does not accept with the underscore ( _ ). For example, the OpenEdge custnum field maps to the CUST_NUM column in Oracle.