Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Increase maximum identifier length from 30 characters to 60 or more

MortenBratenMar 22 2015 — edited Mar 31 2017

Currently the maximum identifier length of tables, columns, packages, functions, etc. is limited to 30 characters.

This should be increased to 60, 90 or more characters, allowing for more flexibility and readability in object naming.

Realize this has the potential to break a lot of old applications, so it should probably be explicitly enabled by a configuration parameter, just like the "32K varchars in tables" option that was introduced in 12c.

Update: Oracle Database 12c R2 provides identifiers up to 128 bytes. For more information see the 12.2 New Features Guide.

Comments

Processing

Post Details

Added on Mar 22 2015
30 comments
68,231 views