Conceptual Info.

• Explain that BETWEEN … AND … is actually translated by the Oracle server to a pair of AND conditions (a >= lower limit) and (a <= higher limit) and IN ( … ) is translated by the Oracle server to a set of OR conditions (a = value1 OR a = value2 OR a = value3). So using BETWEEN … AND … , IN(…) has no performance benefits; the benefit is logical simplicity.
• Oracle issues an implicit commit before and after any data definition language (DDL) statement. So, even if your DDL statement does not execute successfully, you cannot roll back the previous statement because the server issued a commit.
• Tables can have up to 1,000 columns
• Table names and column names (tough to remember terms only):

1. Must begin with a letter
2. Must be 1–30 characters long
3. Must contain only A–Z, a–z, 0–9, _, $, and #