Re: [OT] SQL*Plus output as PDF [Linux]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxx
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux