Field and column names
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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.