问题描述
是否可以在plsql中引用LOV?
Is it possible to reference a LOV in plsql?
我需要从PLSQL的静态LOV中获取显示值，以用作交互式报表的过滤器.
I need to get the display value from a static LOV from PLSQL to use as a filter on an interactive report.
我已经拖曳了文档和Google，但没有提及能够通过plsql引用LOV.
I have trawled the documentation and google but there is no reference to being able to reference a LOV via plsql.
非常感谢收到任何帮助
推荐答案
您可以访问具有LOV的项目的值-通常就是您想要的:
You can access the value of an item that has a LOV - that's usually what you want:
select ename from emp
where deptno = :p1_deptno -- P1_DEPTNO is a page item based on an LOV
对于静态LOV，您可以这样访问显示值:
For static LOVs you can access the display value like this:
select display_value
from apex_application_lov_entries
where application_id = 123
and list_of_values_name = 'DEPT_LOV'
and return_value = :p1_deptno;
对于动态LOV，您必须运行LOV所基于的查询.这可以从视图apex_application_lovs
For dynamic LOVs you would have to run the query the LOV is based on. This can be obtained from view apex_application_lovs
这篇关于APEX LOV显示值查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！