Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to add text string to query response? Help :-(

Re: How to add text string to query response? Help :-(

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 06 Nov 2004 04:48:26 -0800
Message-ID: <1099745238.579371@yasure>


Sparky wrote:

> I'm trying to return a rescord from an oracle db surrounded(wrapped
> by) by 2 text strings
>
> Example -
>
> Select p.p_id
> from person p
> where p.p_name like '%smith%'
>
> returns a list of p_id records -
>
> 1243
> 1236
> 4523
> 2355
>
>
>
> But I want to put a text string before and after each record to make
> them links so I'd get the following repsonse -
>
> <a href="http://www.person.com/person.asp?person=1243">Show person</a>
> <a href="http://www.person.com/person.asp?person=1236">Show person</a>
> <a href="http://www.person.com/person.asp?person=4523">Show person</a>
> <a href="http://www.person.com/person.asp?person=2355">Show person</a>
>
> I've been trying stuff like (admittedly MS style)
>
> Select '<a href="http://www.person.com/person.asp?person=' + p.p_id +
> '">Show person</a>'
> from person p
> where p.p_name like '%smith%'
>
> but just end up with syntax errors every time.
>
> Can anyone help?
>
> I'm sure the answer is simple but I've been googling for an hour!

Go to http://www.psoug.org
click on Morgan's Library
click on String Functions
Scroll down to CONCAT and Vertical Bars

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Nov 06 2004 - 06:48:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US