[CentOS] [OT] SQL*Plus output as PDF [Linux]

Les Mikesell lesmikesell at gmail.com
Wed Apr 13 15:04:40 UTC 2011


On 4/13/2011 9:34 AM, Trutwin, Joshua wrote:
>> I generate with SQL*Plus a CSV file. How to convert this to PDF? Or more
>> generally: how to get SQL*Plus output to PDF on Linux?
>
> Marked as Off Topic.
>
> I would do this:
>
> sqlplus
> SET MARKUP HTML ON
> SPOOL foo.html
> SELECT * FROM emp;
> SPOOL OFF
>
> Quit sqlplus and use htmldoc to convert foo.html to foo.pdf, or load it in a browser and use CutePDF or something to print it to a .pdf if in a hurry.

Or if you want serious overkill, look at the Pentaho BI-server and 
report designer tools.  There are both free (community) and supported 
versions and they are in java and very platform agnostic. The report 
designer is a GUI tool where you can query about any data source and lay 
out the results with pixel level control of formatting, and the 
bi-server is a web platform that lets anyone run the reports on demand 
with output as html, pdf, csv, excel, etc., or it can email them in 
scheduled runs.

-- 
   Les Mikesell
    lesmikesell at gmail.com



More information about the CentOS mailing list