ORA-00923

Hi
I put those ( (1) and (2) ) in my SQL*Plus: Release 8.0.4.0.0 and I got error:
ORA-00923: FROM keyword not found where expected

(1) SELECT mgr, ename, sal,MAX(sal) OVER (PARTITION BY mgr) AS mgr_max
FROM emp;

(2) SELECT mgr, ename, sal FROM (SELECT mgr, ename, sal,

      MAX(sal) OVER (PARTITION BY mgr) AS rmax_sal
      FROM emp)
      WHERE sal = rmax_sal;

(1) and (2) are from Oracle documentation for 8.1.7, I'm using Oracle
8.0.4. Is it the cause why it doesn't work properly ?

Thanks for any answers Received on Fri Feb 28 2003 - 16:23:11 CST