Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to add text string to query response? Help :-(
"Sparky" <mark_ponsford_at_hotmail.com> wrote in message
news:6442e48.0411040900.1c70fac9_at_posting.google.com...
| 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!
one google on 'oracle concatenation operator' should come up with the answer real quick
also, get yourself a copy of the SQL manual at http://tahiti.oracle.com Received on Thu Nov 04 2004 - 11:28:11 CST