Missing optional path on RR design for page 27

42 views
Skip to first unread message

Ligaya Turmelle

unread,
Jan 5, 2016, 9:21:48 AM1/5/16
to Beginning Oracle Database 12c Administration
On page 27 under the subheading "Railroad Diagrams" you have figure 2-2 which has the hypothetical ROW command. This figure is your first introduction to RR diagrams

The examples you give include:

ROW YOUR BOAT
ROW, ROW YOUR BOAT
ROW, ROW, ROW YOUR CORACLE
ROW, ROW, ROW, ROW YOUR PIROGUE
ROW, ROW,ROW, ROW, ROW YOUR LARGE CORACLE

If you look at the railroad diagram you gave for the ROW command, you do not have a "track" to show that the {BIG, LARGE} clause is optional.

This confused me as I tried to learn what and how a RR diagram worked. It was not until 20 minutes later when I moved past this initial example to look at Figure 2.3 of the RR diagram of a SELECT statement that I realized there is a way to show an optional clause and that the first diagram did not include it.


Iggy Fernandez

unread,
Jan 5, 2016, 9:54:52 AM1/5/16
to Beginning Oracle Database 12c Administration
Absolutely correct! I will add your correction to the Errata section on the Apress website. I've attached a corrected version of the diagram.
ROW_statement.png
Reply all
Reply to author
Forward
0 new messages