help with query in oracle, in the session monitor in the sql text query is set up in a different way, for example I have the following query that is loaded in APEX in the After Header:
SELECT a.emp_descripcion, a.emp_id
FROM cbe.employee a
WHERE a.emp_status = 0
AND a.rol_id = 58
AND :f_ses_id IN (677,457,1124)
But, in the session monitor from PLSQL, in the SQL text it shows me that the query is built in a different way:
"select * from(select a.*,row_number() over (order by null) apx$rownum from(select i.*, count(*) over () as APEX$TOTAL_ROW_COUNT
from (select *
from ((select /*+ qb_name(apex$inner) */* from (SELECT a.emp_descripcion, a.emp_id
FROM cbe.employee a
WHERE a.emp_status = 0
AND a.rol_id = 58
AND :f_ses_id IN (677,457,1124)
) d
)) i
) i where 1=1
order by 1 asc nulls last
)a
)where apx$rownum<=:p$_max_rows"