list of values

[cristina10]

I want to make a list of values for a object. By exemple the values are X, Y, Z
When the Values button is touch, it’s open 3 values: X
Y
Z
How I make this?
I make a other object like this 'x' from dual union select 'y', but for Z I don’t know

 

[blom0344]

union will work for more than 2 values:

select 'X' FROM DUAL
UNION
SELECT 'Y FROM DUAL
UNION
SELECT 'Z' FROM DUAL
......
.......

Ties Blom