Skip to main content

Posts

Showing posts from October, 2019

Use record type as an OUT parameter in Oracle PL/SQL Stored Procedure

Objective :  How to print record type values in Oracle PL/SQL . Solution : Step 1:  Create package  fxgn_sample_pkg . DROP PACKAGE  fxgn_sample_pkg ; create or replace   PACKAGE  fxgn_sample_pkg     as         TYPE fxgn_sample_rectype IS RECORD ( p_name varchar2(40),                                                                                               p_emp_id number                                                                                     ); ...

Select list pagination in Oracle APEX 18.2 Interactive Grid (IG)

Objective: To bring select list pagination in Interactive Grid. Solution: Step 1:   Create Interactive Grid. Step 2:   Set   show total row count =  YES. Step 3:  Add the below JS in the JS section of the IG attributes. function(config) {     config.defaultGridViewOptions = {         rowHeader: "sequence",         pagination: {                                                         showRange: true,             showPageSelector: true,             showPageLinks: false, // uncomment to hide the first and last buttons //            firstAn...