Oracle OCP Book - Is This Correct?

I bought a copy of Oracle OCP Introduction to Oracle 9i: SQL Exam Guide from Oracle Press over the weekend and my first thought, other than the fact that no one ran a spell checker on it, is that there are many factual errors.

Any comments on the following will be appreciated.

Pg. 163: "Other types of views that you will learn about in Chapter 7 do not support the use of the order by clause".

Order by is available in all view in Oracle since 8i.

Pg. 203: "A listing of not NULL for the table column usually (although not always) indicates that the table column is the primary key for identifying unique rows in the table.

While primary keys are, by definition, NOT NULL. The statement is not true in my experience by a very wide margin.

Pg. 207: "However, if the select statement includes a specific list of columns named in the column clause, your crate table clause must list the columns you want the table to include, enclosed in parentheses. Here us ab example of what I mean:

    SQL> create table emp_copy_2

               (empno, sal) as
               select empno, sal from emp
               where deptno = 10;

I've never had a problem yet with

    SQL> create table emp_copy_2 as

               select empno, sal from emp
               where deptno = 10;

Thanks for any comments.

Daniel Morgan Received on Tue Jan 22 2002 - 07:08:49 CST