Get Device ID in Oracle APEX

How to Get Device ID in Oracle APEX? Demo Read more

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. The query is parsed as the application owner. If a... Read more

Invoke Web Services using APEX_WEB_SERVICE in Oracle APEX

DECLARE 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) := '{"items":{ "EMAIL_ID": "'||P_EMAIL_ID||'","CC_MAIL":"'||P_CC_MAIL||'"}}'; -- to invoke json , Directly pass Json in parameter value. htp.p(l_parm_values(1)); -- Get the XML response from... Read more

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 a REQUEST value of ‘DELETE’. 2. apex.page.confirm Signature 2. This... Read more

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. EXAMPLE Write an array attribute that contains JSON Read more

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 year else it returns day of current year. SELECT ROUND... Read more

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 (32) ); TYPE l_ret_list_tbl_typ IS TABLE OF l_rec_typ; l_ret_list_tbl l_ret_list_tbl_typ;... Read more

Download files in APEX

Download files in APEX short code. Read more

Generate the DDL of any object in ORACLE

How to generate the DDL of any object in ORACLE? Read more

Upload Multiple Files in Oracle APEX

How to upload multiple files in apex collection using Oracle APEX. Read more