| REGARDING LOV [message #143159] |
Wed, 19 October 2005 05:52  |
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
|
Member |
|
|
I am creating one lov with a record group
select distinct branchid , branchname from branch_master;
so the lov will have the list of distinct branchid like this
101 mysore
102 bangalore
103 kolkata
104 chennai
is it possible to add another value to the list of
branches from branch_master select statement
i want the lov to be like this
000 unknown branch
101 mysore
102 bangalore
103 kolkata
104 chennai
|
|
|
|
|
|
| Re: REGARDING LOV [message #143892 is a reply to message #143588] |
Mon, 24 October 2005 00:11  |
naveednt
Messages: 34
Registered: October 2005
Location: Karachi, Pakistan
|
Member |
|
|
modifying your record group query is the simple way.
use query below in your record group
select '000', 'unknown branch' from dual
union all
select distinct branchid , branchname from branch_master;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
