Implement InitCap function

Marcelo Finkielsztein

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Confidential

Description (Required):

implement InitCap function in Logical SQL. Use the Oracle specification and syntax for further reference

Use Case and Business Need (Required):

Users request to see certain names and descriptions using "Init Cap" mixed case.

e.g.: column for country names. The physical table contains

"UNITED STATES OF AMERICA", "CANADA", "UNITED ARAB EMIRATES"

Users request to see: "United States Of America", "Canada", "United Arab Emirates" on their analyses.

We would like to be able to implement this at the RPD level, in the Business Model/Logical level, without involving changes to the physical layer.

It would be handy to have this also in DV, when we create datasets.

Enhancement Request / Service Request:

N/A

Pravin Janardanam-Oracle

@Marcelo Finkielsztein You can accomplish the same using an EVALUATE function with a database Function.

Syntax 

EVALUATE('db_function(%1...%N)' [AS data_type] [, column1, columnN])

Where:

db_function is any valid database function understood by the underlying data source.

Example for Oracle Database

evaluate('Initcap(%1)',Employee."Employee First Name")

Marcelo Finkielsztein

Thanks for the suggestion.

In our environment, 'evaluate' has been forbidden, due to security concerns.

( The Security Office decided this function could lead to injection )

Only as a side comment ... note that for MS Sql Server users the evalute() would not work, AFAIK, since MS Sql Server does not offer this functionality.

Thanks Again for the suggestion! appreciated!