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.