Re: generate html report using sqlplus
Date: Wed, 23 Jan 2008 05:50:52 -0800 (PST)
Message-ID: <89ca8a44-55f2-43ef-b67e-9c7b5e9c5e31@v29g2000hsf.googlegroups.com>
On Jan 17, 11:53 pm, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
> Using sqlplus, and if u have access to the htp and htf package, it
> should be no problem generating HTML, for example, look at the file
> $ORACLE_HOME/rdbms/admin/privutil.sql, and search for all the htp.*
> function usage, and u can get the idea how it uses htp functions to
> generate HTML structure contents.
>
> For example:
>
> htp.preOpen;
> htp.prints(translate(text,NL_CHAR,' '));
> htp.preClose;
>
> And this:
>
> htp.print('</PRE>');
> htp.p(htf.format_cell(columnValue, format_numbers));
> htp.tableRowOpen;
> htp.tableRowClose;
> htp.tableRowOpen;
> htp.tableRowClose;
> htp.formSelectOpen( cname => p_cname,
> htp.formSelectOption( cvalue => nc_visible,
> htp.formSelectClose;
>
> etc.
Thanks for the valuable tips..
where will htp.print will print? On screen? I would like to generate
the report on client side as I don't have access to server...
Received on Wed Jan 23 2008 - 07:50:52 CST