Select One and Select Many Item Types in Oracle APEX 24.1

We can use ‘select one’, ‘select many’ item type when selecting the department,
The difference between ‘select one’ and ‘select many’ is ‘select many’ can choose many options and return multiple values, while ‘select one’ can only select one value once a time. Select many has two types of ‘multiple values’ return, Delimited List and JSON Array
Delimited List example： ["10","20","30"]
JSON Array 10:20:30
So,when we change the page item P3_DEPTNO, The report will refresh, The Report SQL is:
select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO DEPT,
HOMEPAGE,
PROFILE
from EMP
/********************select one ******************/
-- where deptno = :P3_DEPTNO or :P3_DEPTNO is null
/********************select many delimited list *****************/
-- where deptno in (select column_value from apex_string.split ( :P3_DEPTNO, ':' )) or :P3_DEPTNO is null

/***************************select many JSON Array ************************/
where deptno in (
select
element
from
json_table ( :P3_DEPTNO, '$[*]'
columns
element varchar2 path '$'
)) or :P3_DEPTNO is null