Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

In the session monitor in the SQL text query is set up in a different way

User_VEBWAAug 18 2021

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"


Comments

Processing

Post Details

Added on Aug 18 2021
4 comments
126 views