Databases Reference
In-Depth Information
insert into "BOOK"."CUSTOMERS" values(5,'Schmidt','DE');
insert into "BOOK"."CUSTOMERS" values(6,'Muller','DE');
insert into "BOOK"."CUSTOMERS" values(7,'Garcia','ES');
insert into "BOOK"."CUSTOMERS" values(8,'Martinez','ES');
insert into "BOOK"."CUSTOMERS" values(9,'Rossi','IT');
insert into "BOOK"."CUSTOMERS" values(10,'Moretti','IT');
Next, we'll create our ORDERS table, again column-based, and insert its sample data using
the following SQL statements:
CREATE COLUMN TABLE "BOOK"."ORDERS"
(
"ORDER_ID" INTEGER CS_INT NOT NULL ,
"ORDER_COUNTRY" VARCHAR(20),
"ORDER_YEAR" VARCHAR(4) NOT NULL ,
"CUST_ID" INTEGER CS_INT NOT NULL ,
"ORDER_AMT" INTEGER CS_INT NOT NULL
);
insert into "BOOK"."ORDERS" values(1,'GB','2010',1,100);
insert into "BOOK"."ORDERS" values(2,'GB','2010',2,117);
insert into "BOOK"."ORDERS" values(3,'GB','2011',1,120);
insert into "BOOK"."ORDERS" values(4,'GB','2011',2,135);
insert into "BOOK"."ORDERS" values(11,'FR','2010',3,100);
insert into "BOOK"."ORDERS" values(12,'FR','2010',4,117);
insert into "BOOK"."ORDERS" values(13,'FR','2011',3,120);
insert into "BOOK"."ORDERS" values(14,'FR','2011',4,135);
insert into "BOOK"."ORDERS" values(21,'DE','2010',5,100);
insert into "BOOK"."ORDERS" values(22,'DE','2010',6,117);
insert into "BOOK"."ORDERS" values(23,'DE','2011',5,120);
insert into "BOOK"."ORDERS" values(24,'DE','2011',6,135);
insert into "BOOK"."ORDERS" values(31,'ES','2010',7,100);
insert into "BOOK"."ORDERS" values(32,'ES','2010',8,117);
insert into "BOOK"."ORDERS" values(33,'ES','2011',7,120);
insert into "BOOK"."ORDERS" values(34,'ES','2011',8,135);
insert into "BOOK"."ORDERS" values(41,'IT','2010',9,100);
insert into "BOOK"."ORDERS" values(42,'IT','2010',10,117);
insert into "BOOK"."ORDERS" values(43,'IT','2011',9,120);
insert into "BOOK"."ORDERS" values(44,'IT','2011',10,135);
