Wednesday, January 17, 2018

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

No comments:

Post a Comment