Errata

Oracle SQL*Plus Pocket Reference

Errata for Oracle SQL*Plus Pocket Reference

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

Version Location Description Submitted by Date submitted
Printed Page 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);

 Anonymous