使用 ||来拼接,|| 代表“+”,拼接“||”左右两边的的字符串。
select job_id ||', '|| job_title from jobs;
select job_id || q'('s)' "JOB" from jobs;
使用 ||来拼接,|| 代表“+”,拼接“||”左右两边的的字符串。
select job_id ||', '|| job_title from jobs;
select job_id || q'('s)' "JOB" from jobs;