LvGjRtBD

1Создание таблицы
2
3DROP TABLE IF EXISTS t1;
4CREATE TABLE t1 (
5  id NUMBER NOT NULL PRIMARY KEY,
6  name VARCHAR(20) NOT NULL,
7  type VARCHAR(20) NOT NULL,
8  firm VARCHAR(20) NOT NULL
9);
10	
11Начальное заполнение таблицы
12
13INSERT INTO t1 (id,name,type,firm) VALUES (1,'Access','Реляц','Microsoft');
14INSERT INTO t1 (id,name,type,firm) VALUES (2,'FoxPro','Реляц','Microsoft');
15INSERT INTO t1 (id,name,type,firm) VALUES (3,'Oracle7','Реляц','Oracle');
16INSERT INTO t1 (id,name,type,firm) VALUES (4,'Orion3','ОО','Orion');
17INSERT INTO t1 (id,name,type,firm) VALUES (5,'Orion4','ОО','Orion');
18INSERT INTO t1 (id,name,type,firm) VALUES (6,'Delphi','ОО','Microsoft');
19INSERT INTO t1 (id,name,type,firm) VALUES (7,'Essbase1','Многом','Arbor');
20INSERT INTO t1 (id,name,type,firm) VALUES (8,'Essbase2','Многом','Arbor');
21INSERT INTO t1 (id,name,type,firm) VALUES (9,'Orion5','Многом','Orion');
22INSERT INTO t1 (id,name,type,firm) VALUES (10,'Oracle8','Многом','Oracle');