SELECT T.CITYID,
T.CITYID AS CITYID_DISPLAY,
T.CITYNAME,
COUNTRYID,
(SELECT C.COUNTRYNAME
FROM COUNTRY C
WHERE C.COUNTRYID = T.COUNTRYID)
AS COUNTRYNAME,
'Delete' Del
FROM CITIES T
ORDER BY UPPER (T.CITYNAME) ASC
To exclude CITYID while export/download from Interactive Report:
Select the column -->Server-Side Condition --> Type (PL/SQL Expression) --> Paste below script
nvl(:request, 'EMPTY') not in ('CSV','XLS','PDF','RTF','HTMLD')
and nvl(wwv_flow.g_widget_action, 'EMPTY') <> 'SEND_EMAIL'
No comments:
Post a Comment