CREATE or replace function GET_SIM_REQ_APPROVED_DTL (in_type in varchar2,in_id in number)
return varchar2 is
v_name varchar2(256);
begin
if in_type = 'OPERATOR_REQ_QTY' then
select LISTAGG(RPAD(OPERATOR_NAME, 18, ' ') || ': ' || NVL(REQ_QTY,0),', ') WITHIN GROUP (ORDER BY OPERATOR_NAME) OPERATOR_REQ_QTY
INTO V_NAME
from TABLE_NAME
where ID=in_id;
else
null;
end if ;
RETURN V_NAME;
EXCEPTION WHEN OTHERS THEN RETURN NULL;
END;
==================
For Interactive Grid
==================
Function Call to SQL Query.
Select
'<pre>' || REPLACE(GET_SIM_REQ_APPROVED_DTL('OPERATOR_REQ_QTY', M.ID), ', ', CHR(10)) || '</pre>' AS OPERATOR_REQ_QTY
from TABLE_NAME;
Select "OPERATOR_REQ_QTY" Column.
Type: HTML Expression
<span style="font-family:Segoe UI; font-size:12px; display:block;">&OPERATOR_REQ_QTY.</span>
==================
For Interactive Report
==================
Function Call to SQL Query.
SELECT
'<div style= "width:160px;" >
'<pre>' || REPLACE(GET_SIM_REQ_APPROVED_DTL('OPERATOR_REQ_QTY', M.ID), ', ', CHR(10)) || '</pre>' AS OPERATOR_REQ_QTY
FROM TABLE_NAME;
Column Formatting -->HTML Expression:
<span style="font-family:Segoe UI; font-size:12px; display:block;">#OPERATOR_REQ_QTY#</span>