CentOS - Apr 2011 - [OT] SQL*Plus output as PDF [Linux]

> 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.

Josh

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