SQL - 문자 합치기

1. CONCAT

SELECT CONCAT(COUNTRY_ID, COUNTRY_NAME) FROM COUNTRIES;

SELECT CONCAT(CONCAT(COUNTRY_ID, ' '), COUNTRY_NAME) FROM COUNTRIES;

2. ||

SELECT COUNTRY_ID||COUNTRY_NAME FROM COUNTRIES;

SELECT COUNTRY_ID||' '||COUNTRY_NAME FROM COUNTRIES;