|| 함수

select 칼럼||칼럼을 사용하면 합쳐서 출력 select last_name|| 'test' AS "Employees" from employees; select last_name|| ' is a ' || job_id AS "Employee" from employees;

select department_name || q'[ Department's Manager Id: ]' || manager_id from departments; # 따옴표를 사용하기 위해 q 사용