The CONCAT function returns string1 concatenated with string2.
Concat syntax
CONCAT( string1, string2 )
Concat example
select concat('ab', 'c') from dual; Result: abc select concat('123', '45') from dual; Result: 12345 select concat('PL/SQL', ' Reference') from dual; Result: PL/SQL Reference
Concat example
STUDENT_ID | FIRST_NAME | LAST_NAME | CITY |
---|---|---|---|
1 | Daniel | SCOTT | New York |
2 | Anthony | SIMMONS | Chicago |
3 | Sophia | THOMPSON | Los Angeles |
select s.STUDENT_ID, concat(concat(s.FIRST_NAME,', '), s.LAST_NAME) as FULL_NAME, s.CITY from STUDENTS s ;
STUDENT_ID | FULL_NAME | CITY |
---|---|---|
1 | Daniel, SCOTT | New York |
2 | Anthony, SIMMONS | Chicago |
3 | Sophia, THOMPSON | Los Angeles |