Problem #1240
DATABASE MANAGEMENT SYSTEM USING ORACLE
<p>EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)</p><p>DEPT (DEPTNO, DNAME, LOC)</p><p>Display employees whose name has exactly 1 character after 'A'.</p>
Explanation
EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) DEPT (DEPTNO, DNAME, LOC)