Posted inAPEX JavaScript
Get Device ID in Oracle APEX
How to Get Device ID in Oracle APEX? Create a page with a page item and paste below Javascript in Function and Global Variable Declaration section as per screenshots. Copy CodeCopiedUse a…
Posted inAPEX
APEX_COLLECTION Using CREATE_COLLECTION_FROM_QUERY_B and CREATE_COLLECTION_FROM_QUERY_B2
Referred from Oracle Standard Document . CREATE_COLLECTION_FROM_QUERY_B Procedure Use this procedure to create a collection from a supplied query using bulk operations. This method offers significantly faster performance than the CREATE_COLLECTION_FROM_QUERY method.…
Posted inAPEX
Invoke Web Services using APEX_WEB_SERVICE in Oracle APEX
Directly pass the JSON in parameter value. Copy CodeCopiedUse a different BrowserDECLARE l_parm_names apex_application_global.vc_arr2; l_parm_values apex_application_global.vc_arr2; l_clob CLOB; P_EMAIL_ID varchar2(100):='ashishk392@gmail.com'; P_CC_MAIL varchar2(100):='vikaspandey641@gmail.com'; BEGIN l_parm_names (1) := 'input'; l_parm_values (1) :=…
Posted inAPEX JavaScript
javascript:apex.confirm In Oracle APEX
1. apex.page.confirm Signature 1. This example shows a confirmation dialog with the text ‘Delete Department’. If the user chooses to proceed with the delete, the current page is submitted with…
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…
Posted inAPEX
First Day of the YEAR : ROUND (DATE)
First Day of the YEAR by ROUND function This function works similar to ROUND of numbers, if the month is geater than six (6) then return the day of next…
How to bulk return in FORALL insert?
BULK Return from FORALL insert. CREATE TABLE ashish_bulk_ret ( id NUMBER GENERATED AS IDENTITY PRIMARY KEY, name VARCHAR2 (31) ); DECLARE TYPE l_rec_typ IS RECORD ( id NUMBER, name VARCHAR2…
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:…
Posted inAPEX
Generate the DDL of any object in ORACLE
How to generate the DDL of any object in ORACLE? Copy CodeCopiedUse a different BrowserSELECT DBMS_METADATA.get_ddl ( <OBJECT_TYPE>, <OBJECT_NAME>, <SCHEMA_NAME>) FROM DUAL;
Posted inAPEX
Upload Multiple Files in Oracle APEX
How to upload multiple files in apex collection using Oracle APEX. Create a blank page where there will be a page item and a button as per screenshot. Create a…