Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » LOV with Static and dynamic values (APEX 4.0)
LOV with Static and dynamic values [message #648534] Wed, 24 February 2016 12:40 Go to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi,

Could i have an LOV with static value like ALL then dynaic values from tables ?

Regards
Phil
Re: LOV with Static and dynamic values [message #648543 is a reply to message #648534] Thu, 25 February 2016 02:18 Go to previous message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes; use UNION of two SELECT statements, such as
select 'ALL' d, 'ALL' r from dual
union all
select dname d, deptno r from dept
Previous Topic: Region Template position
Next Topic: : ORA-06550: line 1, column 13: PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared ORA-0655
Goto Forum:
  


Current Time: Wed Aug 05 12:13:03 CDT 2020