Home » SQL & PL/SQL » SQL & PL/SQL » join strings
join strings [message #195359] Thu, 28 September 2006 04:14 Go to next message
Messages: 112
Registered: July 2006
Senior Member

How can I join the string "Product: " in front of the param?

I tried the code below, but it doesn't work.

select 'Product: ' param
from tab

Re: join strings [message #195364 is a reply to message #195359] Thu, 28 September 2006 04:34 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
select 'Product: '||param
from tab

select concat('Product: ',param)
from tab
Previous Topic: getting kup-00554 when creating external table
Next Topic: ORA-13249
Goto Forum:

Current Time: Sat Aug 19 04:23:50 CDT 2017

Total time taken to generate the page: 0.09154 seconds