About Oracle and Oracle ā'pěks (#orclapex)

Objective : To generate multiple excel sheet report from OBIP using data template SQL queries. Scenario : Customer needs multiple sheets excel report from OBIP. While developing it, developer came to know multiple data-set of SQL queries required to complete the report. Developer has to develop the report with single data-set of SQL query, Instead of using multiple data-set of SQL queries. Solution : To develop multiple sheets excel OBIP report using Data template SQL Queries.  Step 1:  Create OBIP report Step 2:   Create data template SQL Queries and place it into data model in OBIP. Step 3:  Data Template SQL Query. S tep 3:  XML data generation. S tep 3:  XML data generation. Output: (Sheet I) Output: (Sheet III)

Objective : To show dynamic help text in radio group item in Oracle APEX 4.2 using CSS. Solution: Step 1:  Create Radio group item. Step 2:  Use below query in radio group LOV Source. <<SQL Begins>> SELECT   ('<span style="cursor:help" title="'   || PRODUCT_DESCRIPTION   || '">'   || PRODUCT_NAME   || '</span>') AS SHOW_VALUE,   PRODUCT_ID RETURN_VALUE FROM   DEMO_PRODUCT_INFO_TBL ORDER BY   1 ); <<End>> Output:

Objective : To read and import XLSX file in Oracle APEX 4.2. Scenario : Customer wants to see their investor details in APEX (in the form of IR). Though investor details are in Oracle Directory (XLSX file format), But what we have done is, we read the XLSX file from Oracle directory and import data in APEX (Interactive Report).  Solution : Step 1:  Create the process in APEX to Call the PL/SQL procedure to generate excel file in oracle directory. Step 2:  Install the  AS_READ_XLSX  Package. << Package Specification <> CREATE OR REPLACE PACKAGE as_read_xlsx IS TYPE tp_one_cell IS   record   (     sheet_nr   NUMBER(2),     sheet_name VARCHAR(4000),     row_nr     NUMBER(10),     col_nr     NUMBER(10),     cell       VARCHAR2(100),     cell_type  VARCHAR2(1),     stri...