O'Reilly logo

Practical SQL Handbook, The: Using SQL Variants, Fourth Edition by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required