Home » SQL & PL/SQL » SQL & PL/SQL » Need a clarification regarding value sets
Need a clarification regarding value sets [message #323235] Tue, 27 May 2008 18:46 Go to next message
maggy_ashee
Messages: 70
Registered: May 2007
Member
Hello All,

I have created a new independent value set, and have created the values for the same.When it gets displayed it has two columns Value and description.I would like to get rid of the column Description and would like to have only one set of columns displayed in the parameter list

For e.g

Now when I tab-out the parameter it gets displayed as follows:

1 one
2 two
3 three

but i want the parameter list to diaplay like

one
two
three

Please let me know if you need some inputs from my side.
All your suggestions are appreciated.




Re: Need a clarification regarding value sets [message #323249 is a reply to message #323235] Tue, 27 May 2008 22:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just select the column you want to display.

Regards
Michel
Re: Need a clarification regarding value sets [message #323815 is a reply to message #323249] Thu, 29 May 2008 10:25 Go to previous message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
maggy_ashee, could it be that you are working in EBS?
Previous Topic: Procedure created by PL/SQL won't compile
Next Topic: simple select from sys.user_tab_columns going all wrong in pl/sql
Goto Forum:
  


Current Time: Sat Feb 15 23:08:27 CST 2025