Posted inAPEX

APEX_JSON.WRITE_RAW

Referred from Oracle Standard Document. APEX_JSON write unescaped JSON write an unescaped array attribute. use the escaping write() procedures instead, if possible. PARAMETERS p_value The value to be written which can…
September 25, 2021
Posted inAPEX

Download files in APEX

Download files in APEX short code. Copy CodeCopiedUse a different Browserbegin sys.htp.init; sys.owa_util.mime_header( <MIME_TYPE>, FALSE ); sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( <BLOB_FILE>)); sys.htp.p('Content-Disposition: attachment; filename="' || <FILE_NAME> || '"' ); sys.htp.p('Cache-Control:…
September 23, 2021
Posted inAPEX

How to upload multiple files in APEX

Referred from Oracle APEX Page Designer Help . How to upload Multiple files in APEX? declare l_file_names apex_t_varchar2; l_file apex_application_temp_files%rowtype; begin l_file_names := apex_string.split ( p_str => :page item name, p_sep =>…
September 22, 2021
Posted inORACLE SQL

How to find ORACLE locked Objects?

Copy CodeCopiedUse a different BrowserSELECT a.osuser, a.sid, b.os_user_name, b.oracle_username, b.session_id, c.object_name, c.object_type FROM v$session a, v$locked_object b, dba_objects c WHERE a.sid = b.session_id AND b.object_id = c.object_id AND c.object_name =…
September 21, 2021
Posted inAPEX

APEX APIs

Referred from Oracle Standard Document . List of APEX APIs APEX_COLLECTION  APEX_AUTOMATION  APEX_CSS  APEX_DATA_EXPORT  APEX_DATA_PARSER  APEX_DEBUG  APEX_ESCAPE  APEX_EXPORT  APEX_IG  APEX_IR  APEX_ITEM  APEX_JAVASCRIPT  APEX_JSON  APEX_LANG  APEX_LDAP  APEX_MAIL  APEX_PAGE  APEX_SESSION  APEX_STRING  APEX_WEB_SERVICE  APEX_ZIP 
September 17, 2021