Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Add INITCAP/PROPER string function
Jim English-Oracle
Rank 3 - Community Apprentice
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Oracle
Description (Required): Add a new string function that works like SQL INITCAP. Like Excel PROPER.
Use Case and Business Need (Required): Many use cases where showing a string with the first letter of each word as upper case is needed. Can include report titles, names, etc.. Database values are commonly stored as all upper or all lower cases but proper case provides a more professional view. There is a workaround using EVALUATE but given the many times proper case is needed, a built-in function is much more desirable.
Enhancement Request / Service Request:
4