So I want the salary returned in the result set to be formatted to this currency type but I believe I am using the to_char in the wrong spot but I'm not sure how. I'm also not sure if I have to use it in both instances of Salary either. Any help would be much appreciated!!
SELECT EMPNO, ENAME, JOB, SAL * 52 TO_CHAR('$999,999') FROM EMP WHERE SAL * 52 > (SELECT AVG(SAL *52) FROM EMP);
I receive the
ORA-00923: FROM keyword not found where expected error from Oracle Apex.
It runs fine without the