Home > book > book errata

book errata

November 26th, 2008
Goto comments Leave a comment

I just received my book today.

It has about 300 pages.

Please post any comments here :

Bookmark and Share

,

  1. Aketi Jyuuzou
    November 26th, 2008 at 22:47 | #1
    Reply | Quote

    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 ;)

  2. Laurent Schneider
    November 26th, 2008 at 22:52 | #2
    Reply | Quote

    do not tell me you have read 111 pages already :)

  3. Laurent Schneider
    November 27th, 2008 at 13:23 | #3
    Reply | Quote

    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 !

  4. Aketi Jyuuzou
    February 25th, 2009 at 15:58 | #4
    Reply | Quote

    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

  5. Laurent Schneider
    February 26th, 2009 at 13:44 | #5
    Reply | Quote

    Very creative OR join :)

  1. No trackbacks yet.