Database Reference
In-Depth Information
Figure 15.9
Multiple-Table
INSERT
Command Syntax.
CREATE TABLE AMAZON AS SELECT * FROM SALES WHERE ROWNUM < 1;
CREATE TABLE BANDN AS SELECT * FROM SALES WHERE ROWNUM < 1;
CREATE TABLE CDSHOP AS SELECT * FROM SALES WHERE ROWNUM < 1;
Figure 15.10
SALES Table
Entries Are
Distributed Among
Three Different
Retailers.
