OraFAQ Forum: SQL & PL/SQL » concatenating a string and a number

Home » SQL & PL/SQL » SQL & PL/SQL » concatenating a string and a number

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

concatenating a string and a number [message #38593]

Mon, 29 April 2002 09:52

Jared
Messages: 10
Registered: June 2001

Junior Member

I want to concatenate a string and a number together and store it as a string. Something like:

'string' + 17 => 'string17'

I tried doing something like this:

new_string = 'string' || 17

But I get errors upon execution. I also tried using to_char(17), but that doesn't fix it. Any ideas?

Thanks!

Jared

Report message to a moderator