Oracle/ Pl/sql proc to generate excel file
Zoran wrote at 2012-10-07 07:33:23
if you need formatted Excel document, there is PL/SQL package called ORA_EXCEL that can generate formatted Excel XLSX documents.
There are a lots of examples on projects page:
ORA_EXCEL wrote at 2013-07-24 17:37:57
To create well formated Excel xslx documents directly from PL/SQL you can use ORA_EXCEL package (www.oraexcel.com) which provides API to most used Excel function through PL/SQL code.
For more details and examples check on:
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.
15+ years of Oracle PL/SQL Development
Education/Credentials B.Sc (Electronics), Diploma in Computer Applications (DCA) Awards and Honors Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000