Search code examples
sqloracle-databaseplsqlstring-concatenation

What is the string concatenation operator in Oracle?

What is the string concatenation operator in Oracle SQL?

Are there any "interesting" features I should be careful of?

(This seems obvious, but I couldn't find a previous question asking it).

Solution

  • It is ||, for example:

    select 'Mr ' || ename from emp;

    The only "interesting" feature I can think of is that 'x' || null returns 'x', not null as you might perhaps expect.