5 Replies Latest reply: May 2, 2012 12:57 PM by 896188 RSS

    Bold the data

      select 'sal' as A from dual
      union all
      select 'Comm' from dual



      How can i make the sal as bold. I would like to do only Sal. is there anyway i can put this in select query

      Edited by: 893185 on May 1, 2012 2:39 PM
        • 1. Re: Bold the data
          It really depends on where do you execute this statement. If you execute this in some kind of html region then you could add <bold> tag inside query.

          select '<bold>' || 'sal' || '</bold>' as A from anytable
          union all
          select 'Comm' from anytable
          • 2. Re: Bold the data
            It is in Reports region. it is not html region. It is classic report

            Edited by: 893185 on May 1, 2012 3:26 PM
            • 3. Re: Bold the data
              "910011"'s solution will suffice, although not necessarily 'best' practice (placing literal values in SQL).

              Other options include using the Column Formatting options in the column definition - this may also require other hidden columns to be present, if using HTML expression to solve your particular problem.

              Another option is to use a report template, similar to the way "Alternative Row Colour" works.

              Both of you, please update your forum profile with a real handle instead of a bunch of numbers, in the interests of politeness ;-)
              • 4. Re: Bold the data
                I think the tag you are looking for is
                i.e. i don't think
                is a valid tag.

                To expand on scotts suggestions, i think something like this:

                select 'Sal' as a, 'bold' css from dual
                union all
                select 'Comm', 'normal' css from dual
                Making the css column hidden.

                Adding a html expression to the field such as:
                <span style="font-weight: #CSS#">#A#</span>
                e.g. http://apex.oracle.com/pls/apex/f?p=64351:4
                • 5. Re: Bold the data
                  Awesome. Thank you.