Oracle SQLPLUS环境与查询实验报告

16、SELECT ENAME FROM EMP WHERE ENAME LIKE ‘S%’； 17、SELECT ENAME，MGR FROM EMP 18、SELECT EMPNO，ENAME，SAL FROM EMP WHERE DEPTNO = &DEPARTMENT_NUMBER; Enter value for department_number:10 19、SELECT EMPNO，ENAME，SAL*12 FROM EMP WHERE JOB = ‘&JOB_TITLE’; Enter value for job_title: MANAGER 20、select to_char(8897) from dual;