Categories
- All Categories
- 149 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- 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