Solution 1:
double bars are concatination:
select 'hello' || ' ' || 'world' from dual;
yields
'hello world'
What does double bars (||) mean in SQL? [duplicate]
Solution 1:
double bars are concatination:
select 'hello' || ' ' || 'world' from dual;
yields
'hello world'