RE: sqlplus "markup html on" format a column

  • From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
  • To: "_oracle_L_list" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 18 Sep 2006 10:35:45 -0400

    The answer to your basic question is no, not in SQL.  Problem is
that you have to do some logical if-then-else processing which you can't
do in Sql alone.  I tried it many moons ago & failed miserably. Try
looking into PHP where you can extract the data & there make the logical
choices.  That's where I succeeded.

Dick Goulet, Senior Oracle DBA

45 Bartlett St  Marlborough, Ma 01752, USA
Tel.: 508.573.1978 |Fax:  508.229.2019 | Cell:508.742.5795 




From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of BN
Sent: Friday, September 15, 2006 1:44 PM
To: _oracle_L_list
Subject: sqlplus "markup html on" format a column


Oracle, 9iRe2 and 10g running on HP-UX, SUN and AIX

I am pulling the data from produciton database on displying on the web
pages for trending data

I display multiple columns, I would like to display a particualr column
in a different format, like change color, make it bold, change font
etc., to catch the user. 

Can somebody tell me if this is doable.

I am using  unix Kshell and SQL for this, nothing else. We are using

Regards & Thanks

GIF image

Other related posts: