Prev: TimeStamp
Next: Oracle Portal - Personalize Page Customization
From: sybrandb on 29 Jan 2008 16:32
On Tue, 29 Jan 2008 11:28:18 -0800 (PST), maks71(a)gmail.com wrote:

>On Jan 23, 11:19�am, "fitzjarr...(a)cox.net" <fitzjarr...(a)cox.net>
>wrote:
>> On Jan 23, 7:50�am, mak...(a)gmail.com wrote:
>>
>>
>>
>>
>>
>> > On Jan 17, 11:53�pm, Peter Teoh <htmldevelo...(a)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...- Hide quoted text -
>>
>> > - Show quoted text -
>>
>> Most likely on the server, as that is where Oracle DIRECTORY objects
>> are defined and I doubt that you have an NFS mount from the db server
>> to the client.
>>
>> David Fitzjarrell- Hide quoted text -
>>
>> - Show quoted text -
>
>Is there a html tag that retain the output of DBMS_XPLAN.DISPLAY ..
>i.e. CR, LF, SPACES and TABS as it is..

Actually you don't need to use htp.print.
Sql*plus has for quite some time the command
set markup html spool on.
(From memory).
You need to verify this in the sql*plus users and reference manual.
Apart from that: isql*plus generates html output by default.

--
Sybrand Bakker
Senior Oracle DBA
From: shakespeare on 31 Jan 2008 06:25

<sybrandb(a)hccnet.nl> schreef in bericht
news:eo6vp3pvbnefjndao44ukdkuase9usjk28(a)4ax.com...
> On Tue, 29 Jan 2008 11:28:18 -0800 (PST), maks71(a)gmail.com wrote:
>
>>On Jan 23, 11:19 am, "fitzjarr...(a)cox.net" <fitzjarr...(a)cox.net>
>>wrote:
>>> On Jan 23, 7:50 am, mak...(a)gmail.com wrote:
>>>
>>>
>>>
>>>
>>>
>>> > On Jan 17, 11:53 pm, Peter Teoh <htmldevelo...(a)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...- Hide
>>> > quoted text -
>>>
>>> > - Show quoted text -
>>>
>>> Most likely on the server, as that is where Oracle DIRECTORY objects
>>> are defined and I doubt that you have an NFS mount from the db server
>>> to the client.
>>>
>>> David Fitzjarrell- Hide quoted text -
>>>
>>> - Show quoted text -
>>
>>Is there a html tag that retain the output of DBMS_XPLAN.DISPLAY ..
>>i.e. CR, LF, SPACES and TABS as it is..
>
> Actually you don't need to use htp.print.
> Sql*plus has for quite some time the command
> set markup html spool on.
> (From memory).
> You need to verify this in the sql*plus users and reference manual.
> Apart from that: isql*plus generates html output by default.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

The OP mentioned that in his post...

Shakespeare


 | 
Pages: 1
Prev: TimeStamp
Next: Oracle Portal - Personalize Page Customization