Monday 2 January 2017

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.


By
Karkuvelraja T

3 comments:

  1. It's interesting to read blog about punchout cxml.
    Punchout CXML

    ReplyDelete
  2. Hey Man! When you need any file converter for your XlSX, PDF, file then use this;

    Online Fine Converter

    ReplyDelete
  3. That can help you to transfer one file to another including these;

    Swf to Avi

    Wmv to Psp

    xlxs to Csv

    Jpg to Tiff

    Tiff to Tif

    ReplyDelete