Oracle Business Intelligence (OBIEE)
Monday, April 25, 2011
Converting the data in column from Upper case to Camel Case
Two ways to achieve this functionality are listed Below:
UPPER(SUBSTRING(Comment_Text FROM 1 FOR 1)) || upper(substring(Comment_Text.STATUS FROM 2))
or
EVALUATE(‘INITCAP(%1)‘, Table.ColumnName)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment