OraFAQ Forum: SQL & PL/SQL » Adding dummy value to list of selected values

Home » SQL & PL/SQL » SQL & PL/SQL » Adding dummy value to list of selected values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Adding dummy value to list of selected values [message #193061]

Thu, 14 September 2006 13:29

welchaz
Messages: 23
Registered: April 2005
Location: Tucson, AZ

Junior Member

I want to populate the values in a drop-down list through this query, except that I want one additional value to appear: "ALL". Can I add in this dummy value to the select statement somehow?

Here's the simple query and results:

select ID_STOREROOM From storeroom_tbl where fg_active='Y';

ID_STOREROOM
CENTRAL
SC
ENOGALES

I would like results to be:
ID_STOREROOM
ALL
CENTRAL
SC
ENOGALES

Thanks in advance.

Report message to a moderator

Re: Adding dummy value to list of selected values [message #193062 is a reply to message #193061]

Thu, 14 September 2006 13:39

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

select ID_STOREROOM
  From storeroom_tbl 
 where fg_active='Y'
union all
select 'ALL'
  from dual;

Report message to a moderator

Re: Adding dummy value to list of selected values [message #193064 is a reply to message #193061]

Thu, 14 September 2006 13:46

welchaz
Messages: 23
Registered: April 2005
Location: Tucson, AZ

Junior Member

Perfect! I knew it was something simple. Thanks very much!

Report message to a moderator

Previous Topic:	Column Heading in The Output
Next Topic:	Cursor Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 08:45:17 CST 2024