const tre = this.triggeringElement;
const tde = tre.querySelector("span[data-deptno]");
const deptno = tde ? tde.dataset.deptno : null;
if ( deptno ) {
apex.item("P1_DEPTNO").setValue(deptno);
}
select sql_id, sql_text from v$sql where sql_text like '%CHECK_FOR_EXECUTIONS%';
クラシック・レポートが発行するSELECT文は、ページ送りなどを可能にするために、実際のソースであるSELECT文をインライン・ビューにしています。
SQL> select sql_id, sql_text from v$sql where sql_text like '%CHECK_FOR_EXECUTIONS%';
SQL_ID SQL_TEXT
________________ __________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
fykf2n6mxnw57 select /*+qb_name(apex$112_1)*/* from(select a.*,row_number()over(order by null)apx$rownum from(select i.* from (select "EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO" from(select /*+ qb_name(apex$inner) */d."EMPNO",d."ENAME",d."JOB",d."MGR",d."HIREDATE",d."SAL",d."COMM",d."DEPTNO" from(select x.* from "EMP" x where(deptno = :P1_DEPTNO /* CHECK_FOR_EXECUTIONS */ ) )d )i )i where 1=1 order by "EMPNO" asc nulls last )a )where apx$rownum<=:p$_max_rows
fykf2n6mxnw57 select /*+qb_name(apex$112_1)*/* from(select a.*,row_number()over(order by null)apx$rownum from(select i.* from (select "EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO" from(select /*+ qb_name(apex$inner) */d."EMPNO",d."ENAME",d."JOB",d."MGR",d."HIREDATE",d."SAL",d."COMM",d."DEPTNO" from(select x.* from "EMP" x where(deptno = :P1_DEPTNO /* CHECK_FOR_EXECUTIONS */ ) )d )i )i where 1=1 order by "EMPNO" asc nulls last )a )where apx$rownum<=:p$_max_rows
fykf2n6mxnw57 select /*+qb_name(apex$112_1)*/* from(select a.*,row_number()over(order by null)apx$rownum from(select i.* from (select "EMPNO","ENAME","JOB","MGR","HIREDATE","SAL","COMM","DEPTNO" from(select /*+ qb_name(apex$inner) */d."EMPNO",d."ENAME",d."JOB",d."MGR",d."HIREDATE",d."SAL",d."COMM",d."DEPTNO" from(select x.* from "EMP" x where(deptno = :P1_DEPTNO /* CHECK_FOR_EXECUTIONS */ ) )d )i )i where 1=1 order by "EMPNO" asc nulls last )a )where apx$rownum<=:p$_max_rows
g8b4vm8rxk618 select sql_id, sql_text from v$sql where sql_text like '%CHECK_FOR_EXECUTIONS%' and sql_text like '%P1_DEPTNO%'
2q370ccg7afva select --+qb_name(apex$4000_4500) no_merge(@apex$inner d) * from (select * from(select /*+ qb_name(apex$inner) */* from(select x.* from "EMP" x where(deptno = :P1_DEPTNO /* CHECK_FOR_EXECUTIONS */ ) )d )i )
d5yrrbtwtyquy select sql_id, sql_text from v$sql where sql_text like '%CHECK_FOR_EXECUTIONS%'
6行が選択されました。
SQL>
SQL> select executions, sql_id from v$sql where sql_id = 'fykf2n6mxnw57' and executions > 0;
EXECUTIONS SQL_ID
_____________ ________________
222 fykf2n6mxnw57
SQL>
Departmentsの列の上を3往復くらいしてみます。
SQL> /
EXECUTIONS SQL_ID
_____________ ________________
228 fykf2n6mxnw57
SQL>
SQL> /
EXECUTIONS SQL_ID
_____________ ________________
228 fykf2n6mxnw57
SQL>
SQL> /
EXECUTIONS SQL_ID
_____________ ________________
249 fykf2n6mxnw57
SQL>