ORACLE - How concatenate two strings

Use operator || or concat() function:

select 'This' || ' is text' from dual;

select concat( 'This', ' is text' ) from dual;

Output:

'THIS'||'IST
------------
This is text

CONCAT('THIS
------------
This is text