ORACLE CONCAT FUNCTION

ORACLE CONCAT FUNCTION

                conact FUNCTION CONCATENATE 2 STRINGS.

syntax: CONCAT(STR1,STR2);

SQL>SELECT CONCAT('HELLO',' WORLD') FROM DUAL;

CONCAT('HELLO',' WORLD')

---------------------------------------

HELLO WORLD

SQL>
SELECT CONCAT('HELLO',NULL) FROM DUAL;

CONCAT('HELLO',NULL)

---------------------------------

HELLO

 

SQL>SELECT CONCAT(NULL,' WORLD') FROM DUAL;

CONCAT(NULL,' WORLD')

---------------------------------------

 WORLD

CONCATENATE 'I' , 'LOVE','PARIS'  USING CONCAT

SQL> SELECT CONCAT(CONCAT('I','LOVE'),'PARIS') FROM DUAL;

CONCAT(CON
----------
ILOVEPARIS