GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
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 3:52 AM by 973331
Convert comma-separated parameter list to upper case
Mar 19, 2013 3:52 AM
Currently Being Moderated
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?
Track in Communications
- 10 points
- 5 points