OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » LOV with Static and dynamic values

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » LOV with Static and dynamic values (APEX 4.0)

Wed, 24 February 2016 12:40

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

Thu, 25 February 2016 02:18

Littlefoot
Messages: 21757
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: Sun Feb 05 14:52:39 CST 2023