- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Increase maximum identifier length from 30 characters to 60 or more
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.