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