Objective: To create template for generating multiple sheet excel in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Excel contains the below template with Sheet1 and 2…
Read MoreObjective: 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…
Read MoreObjective: To download blob files (ZIP Files) from table in APEX using Oracle PL/SQL. Scenario: Customer has asked us to give the provision in APEX, which is used to download…
Read MoreStep 1: Create below Package in DB. Package Spec create or replace PACKAGE doy_PK_APEX_EXCEL_DOWNLOAD IS TYPE query_res IS REF CURSOR; PROCEDURE excel_initialize; PROCEDURE print_headings; PROCEDURE set_sql ( p_session_id IN NUMBER, p_app_id …
Read MoreStep 1: Create a new page with popup template (Page No -2175). Step 2: Create 2 region in old (Calling) Page and write the below scripts in region source. Create…
Read MoreUpload and Download of Files from Server Step 1: Create a File browse item. Step 2: Create a directory in database. Step 3: Create a procedure to upload file in…
Read MoreRequirement: Lazy loading in Oracle Apex Step1: Create a page Step 2: Create a report region Step 3: Create a hidden page item Ex : P1_HIDDEN Step 4: Create on-…
Read MoreMultiple Indexes SQL>CREATE TABLE t3 (col1 NUMBER, col2 NUMBER); TABLE created. SQL>CREATE INDEX in_t3 ON t3(col1); INDEX created. SQL>CREATE INDEX in_t3_02 ON t3(col1); CREATE INDEX in_t3_02 ON t3(col1) * ERROR…
Read MoreAP Invoice On Hold Report Description Invoice on Hold Report is used to review detailed information about invoices on hold. You can submit the Approval process before submitting this report…
Read MorePACKAGE Helper authid Definer accessible BY(Good_Unit,Bad_Unit)ISPROCEDURE p;END Helper;PACKAGE body Good_UnitISPROCEDURE pISBEGIN Helper.p(); …END p;END Good_Guy;PACKAGE body Bad_UnitISPROCEDURE pISBEGIN Helper.p(); …END p;END Bad_Guy;
Read More