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

2 comments:

  1. If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (even if they're dating somebody else now) you must watch this video
    right away...

    (VIDEO) Text Your Ex Back?

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

    ReplyDelete