[Oracle] 문자열 합치는 방법(||, CONCAT())

CONCAT 함수

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

||

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