COLLECTION Sample Data Loading into Table Create a table for loading data. Demo #JoelKallmanDay Read more
Referred from John’s cookbook sample app. // Add the progress indicator. An alternative would be to add this to a page template. $("#t_Header .t-Header-logo").append('<div id="progress" class="progress-bar stripes"><span></span></div>'); Read more
Referred from John’s cookbook sample app. SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM FROM emp Read more
Referred from John’s cookbook sample app. .gv-nested-tbl { border-collapse: collapse; width: 100%; } .gv-nested-tbl td, .gv-nested-tbl th { border: 1px solid #EAEAEA; } .a-GV-row { height: 50px; } <table class='gv-nested-tbl'><thead><tr><th colspan=3>Country</th></tr><tr><th>Born</th><th>Died</th><th>Age</th></tr></thead></table> <table class='gv-nested-tbl'><tbody><tr><td colspan=3>&COUNTRY.</td></tr><tr><td>&FROM_YR.</td><td>&TO_YR.</td><td>&AGE.</td></tr></tbody></table> NOTE: Use COUNTRY, FROM_YR, TO_YR and AGE are... Read more
Referred from John’s cookbook sample app. Referenced/Copied from John’s Cookbook We can refer above CSS snippet for other CSS tricks in GRID. Read more
Referred from John’s cookbook sample app. Strip Plane Hello <h1> Hello</h1> Updates on 7th January 2023 APEX has added this as a new feature by adding this as function into APEX_ESCAPE API. Read more
Referred from John’s cookbook sample app. Read more
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
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