Search code examples
sqloracle-databaseora-01722

Oracle query error

I'm quite new to Oracle and seem to having some problems with my query

Here's what i've got

SELECT (REPLACE(column1, 'test', '') + ': ' + column2) AS column3 FROM table

I get a ORA-01722 invalid number error with this.

I think it's something to do with the +'s but i'm not sure what the correct syntax is.

Any ideas?

Solution

  • You should use || to concat two strings...

    SELECT (REPLACE(column1, 'test', '') || ': ' || column2) AS column3 FROM table