This page lists unconfirmed errors and comments from readers.
They have not yet been approved or disproved by the author or 
editor and represent solely the opinion of the reader.

Oracle SQL*Plus Pocket Reference, 3e
by Jonathan Gennick

The catalog page for this title is http://www.oreilly.com/catalog/9780596528904/

This page was last updated Wed Feb 27 16:34:02 EST 2008.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy
or the digital version accessed.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem


UNCONFIRMED errors and comments from readers:

[57] 1st paragraph;
In the UPDATE example:

UPDATE enrollment e
SET (course_name, period) = (
SELECT course_name, period
FROM course c
WHERE c.course_name = e.course_name
AND c.period = e.period);

because aliases have been used for "enrollment" and "course", isn't it required to use the alias "e" for columns being SET and "c" for columns in the SELECT?

Shouldn't the UPDATE example be as follows?

UPDATE enrollment e
SET (e.course_name, e.period) = (
SELECT c.course_name, c.period
FROM course c
WHERE c.course_name = e.course_name
AND c.period = e.period);