book errata Post author By Laurent Schneider Post date November 26, 2008 6 Comments on book errata I just received my book today. It has about 300 pages. Please post any comments here :
Aketi Jyuuzou November 26, 2008 at 22:47 In page 111, “select min(sal),max(sal) from emp” returns 2 rows. But without “group by” Query does not return 2 rows. I suppose this is a typo 😉
Laurent Schneider Post authorNovember 26, 2008 at 22:52 do not tell me you have read 111 pages already 🙂
Laurent Schneider Post authorNovember 27, 2008 at 13:23 The maximum and minimum salary can be returned as a single row SELECT MIN(SAL),MAX(SAL) FROM EMP; MIN(SAL) MAX(SAL) --------- -------- 800 5000 801 damned microsoft word autocorrection… I will use vi for my next book !
Aketi Jyuuzou February 25, 2009 at 15:58 Question4 of page 64, Altough I cannot recommend,We can avoid InLineView. select d.dname,e.ename,e.job from scott.dept d,scott.emp e where d.deptno = e.deptno(+) and 1 = decode(e.job(+),’MANAGER’,1,’PRESIDENT’,1); actually,We no longer need above usage ,because we can use ANSI Left join since Oracle9i 😉 This thread mentions same usage. http://forums.oracle.com/forums/thread.jspa?threadID=126080
In page 111,
“select min(sal),max(sal) from emp” returns 2 rows.
But without “group by” Query does not return 2 rows.
I suppose this is a typo 😉
do not tell me you have read 111 pages already 🙂
The maximum and minimum salary can be returned as a single row
SELECT MIN(SAL),MAX(SAL) FROM EMP;
MIN(SAL) MAX(SAL)
--------- --------
800 5000
801
damned microsoft word autocorrection… I will use vi for my next book !
Question4 of page 64,
Altough I cannot recommend,We can avoid InLineView.
select d.dname,e.ename,e.job
from scott.dept d,scott.emp e
where d.deptno = e.deptno(+)
and 1 = decode(e.job(+),’MANAGER’,1,’PRESIDENT’,1);
actually,We no longer need above usage ,because we can use ANSI Left join since Oracle9i 😉
This thread mentions same usage.
http://forums.oracle.com/forums/thread.jspa?threadID=126080
Very creative OR join 🙂
On page 54, the DAY keyword of interval ‘1’ / 7 is missing. 🙂