オラクルSQLで列名を別名で表示させる方法 select worker.empno ||',' || worker.ename|| ',' || worker.hiredate||','|| mgr.ename "Employee Number, Employee Name,Hiredate, Mgr Name." from emp worker , emp mgr where worker.mgr=mgr.empno; ERROR at line 1: ORA-00972: identifier is too long select worker.empno AS EmployeeNumber,worker.ename,worker.hiredate,mgr.ename from emp worker , emp mgr where worker.mgr=mgr.empno; ERROR at line 1: ORA-00923: FROM keyword not found where expected

SQL`AS``"Employee Number, Employee Name,Hiredate, Mgr Name."`50

Oracle 12.230
12.2128`ORA-00972`
SO

SQL
`mgr.ename``from`