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
Messages: 112
Registered: February 2016
Senior Member

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

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
Messages: 21809
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: Mon May 20 23:19:55 CDT 2024