Once you've built the tables, it is easy to fill them with data, although you may need to change or remove the statement terminator. After running the INSERT statements, check rows in tables with a command like the following:SQL
select count(*) from authors
The target results for each table are shown in Figure D.1.
For Oracle, the ampersand (&) is the variable marker. When you insert rows into publisher, avoid problems with & in either of these ways:
Change the & in “Binnet & Hardley” so that the company name becomes “Binnet and Hardley” or “Binnet + Hardley”
Turn off variable substitution ...