Skip to main content

Posts

Showing posts from March, 2016

Generate xls, xlsx file in Oracle Directory Using Oracle PL/SQL

Objective : To generate xls, xlsx file in Oracle Directory using Oracle PL/SQL. Scenario : Customer asks us to generate excel report in oracle directory itself; from there customer will download the report. The report should be in the format of xls (or) xlsx. Solution : Step 1:  Call the PL/SQL procedure to generate excel report in oracle directory. Step 2:  Procedure P_GEN_EXCEL_REPORT_DIR. Conclusion:  This procedure will help us to generate Excel (xls, xlsx) file in oracle directory through PL/SQL.