Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

INSERT Statements

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.

Figure D.1. Number of Rows in Each Table

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 ...