APEX LOV显示值查询 [英] APEX LOV Display value look up

问题描述

是否可以在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显示值查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！