Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence (PeopleSoft)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 19, 2013 5:52 AM by
Convert comma-separated parameter list to upper case
Mar 19, 2013 5:52 AM
I have a report that has a parameter called KitItemList that is defined as a "Text field contains comma-separated values " Text field.
I want to be able to convert the parameters entered to upper case but it does not work to simply say upper(:KitItemList) in my select statement.
So I have tried the following
WITH t AS (SELECT :KitItemList AS Item FROM dual)
SELECT upper(Item) FROM t
but only one (the last) element of the list is returned.
How do I get the constituent comma-separated entries to upper case?
This content has been marked as final.
Show 0 replies