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

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

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
> SPOOL foo.html
> SELECT * FROM emp;
> 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