연습문제

-- 연습문제 1
SELECT name || '''s ID : ' || id || ', WEIGHT is ' || weight || 'Kg' "ID AND WEIGHT"
FROM student;

 

-- 연습문제 2
SELECT ename || '(' || job || ') , ' || ename || '''' || job || '''' "NAME AND JOB"
FROM emp;

 

-- 연습문제 3
SELECT ename || '''s sal is $' || sal "Name and Sal"
FROM emp;