Forum Stats

  • 3,872,036 Users
  • 2,266,368 Discussions
  • 7,911,033 Comments

Discussions

format text in the stored procedure

717727
717727 Member Posts: 64
edited Oct 18, 2010 2:40PM in SQL & PL/SQL
Hi,

I am wondering if it is possible to format text in the stored procedure. I would like to add <br> and <b> tags. how I can add it in the following.


It display the data on the map and I want to display it on multiple line as well few text to be bold. do I have to use view or something else.?

please help
Tagged:

Answers

  • BluShadow
    BluShadow Member, Moderator Posts: 42,540 Red Diamond
    edited Apr 30, 2010 10:02AM
    user8723008 wrote:
    Hi,

    I am wondering if it is possible to format text in the stored procedure. I would like to add &lt;br&gt; and &lt;b&gt; tags. how I can add it in the following.


    SELECT c.ID, 'Address ' || c._address ||
    'Property PIN ' || c.PIN ||
    'Property Type:' || c.GIS_PROP_TYPE ||
    'Property Size:' || c.est_size_ac || '(ac)' ||
    'Click for Details...' as description,
    FROM address_pts ca

    It display the data on the map and I want to display it on multiple line as well few text to be bold. do I have to use view or something else.?
    What's the problem with adding those tags into your string concatenation?
    I assume you are returning the data to a web front end for display?

    Edited by: BluShadow on Apr 30, 2010 3:01 PM
    made the tags in orginal message show
    BluShadow
This discussion has been closed.