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 -
Trutwin, Joshua