Errata for SQL Pocket Guide
Submit your own errata for this product.
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
In the book, you said that:
Returns 0 for the root node of a hierarchy, 1 for nodes just
below the root, 2 for the next level of nodes, and so forth.
LEVEL is commonly used in SQL*Plus to indent hierarch-
ical results via an incantation such as the following:
But from oracle documentation we know that the level pseudocolumn returns 1 for a root row, 2 for the child of root.
||Jul 31, 2011
Not really an error; just that MySQL (5.5) will return ugly "NULL" values in those rows created to contain a generated "ROLLUP" value. So, taking a previous section into account - and no doubt distracting a little from the point of the example - you may consider the following instead:
coalesce(t.name, '* total *') as "Tour name",
coalesce(c.name, '* subtotal *') as 'County name',
count(*) as 'Number of falls'
from upfall u
inner join trip t on u.id = t.stop
inner join county c on u.county_id = c.id
group by t.name, c.name with rollup;
||Sep 13, 2012
COMMENT clause line
It appears the page number referenced for this item is in error and it is combined with another line that should be separate below it but is repeated as well....
||Nov 13, 2012