|
29.01.2020, 19:08
#39920162
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
Добрый вечер, при попытке выполнить фрагмент выдает ошибку ORA-00933: неверное завершение SQL-предложения.
Только учусь, прошу более знающих людей указать на ошибки.
Сам код:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
CREATE SEQUENCE "LIBRARY"."AUTO_INC" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
REM INSERTING into LIBRARY.AUTHORS
SET DEFINE OFF;
Insert into LIBRARY.AUTHORS (ID,NAME) values ('4','Лев Ландау');
Insert into LIBRARY.AUTHORS (ID,NAME) values ('5','Лев Толстой');
Insert into LIBRARY.AUTHORS (ID,NAME) values ('6','Дарья Донцова');
Insert into LIBRARY.AUTHORS (ID,NAME) values ('7','Сэл Рэйчел');
Insert into LIBRARY.AUTHORS (ID,NAME) values ('24','Обычный писатель');
REM INSERTING into LIBRARY.BOOKS
SET DEFINE OFF;
Insert into LIBRARY.BOOKS (ID,NAME,YEAR,PLACE,PAGECOUNT,HEADING,TYPE,HALL,COUNT,RARE) values ('26','Просто книга','1994','М','333','15','8','0','5','1');
REM INSERTING into LIBRARY.BOOKTYPES
SET DEFINE OFF;
Insert into LIBRARY.BOOKTYPES (ID,NAME) values ('8','Учебник');
Insert into LIBRARY.BOOKTYPES (ID,NAME) values ('12','Монография');
Insert into LIBRARY.BOOKTYPES (ID,NAME) values ('13','Диссертация');
Insert into LIBRARY.BOOKTYPES (ID,NAME) values ('14','Художественная литература');
REM INSERTING into LIBRARY.CERTIFICATES
SET DEFINE OFF;
Insert into LIBRARY.CERTIFICATES (SERIE,NUM,ID) values ('XX-БК','123456','30');
Insert into LIBRARY.CERTIFICATES (SERIE,NUM,ID) values ('XL-ЧП','123456','31');
REM INSERTING into LIBRARY.DISTRIBUTION
SET DEFINE OFF;
Insert into LIBRARY.DISTRIBUTION (READER,BOOK,GET,RETURN) values ('28','26',to_date('15.01.20','DD.MM.RR'),to_date('19.01.20','DD.MM.RR'));
REM INSERTING into LIBRARY.HEADINGS
SET DEFINE OFF;
Insert into LIBRARY.HEADINGS (ID,NAME) values ('15','Естественные науки');
Insert into LIBRARY.HEADINGS (ID,NAME) values ('20','Технические науки');
Insert into LIBRARY.HEADINGS (ID,NAME) values ('21','Гуманитарные науки');
Insert into LIBRARY.HEADINGS (ID,NAME) values ('22','Религия, философия');
Insert into LIBRARY.HEADINGS (ID,NAME) values ('23','Художественная литература');
REM INSERTING into LIBRARY.PASSPORTS
SET DEFINE OFF;
Insert into LIBRARY.PASSPORTS (SERIE,NUM,ID) values ('1234','123457','29');
REM INSERTING into LIBRARY.READERS
SET DEFINE OFF;
Insert into LIBRARY.READERS (ID,SURNAME,NAME,PATRONYMIC,EMAIL,DEBT,CERT,PASSPORT) values ('28','Иванов','Иван','Иванович','a@example.com','0',null,null);
REM INSERTING into LIBRARY.USERS
SET DEFINE OFF;
Insert into LIBRARY.USERS (LOGIN,PASSWORD,ADMIN) values ('admin','1111','1');
REM INSERTING into LIBRARY.WRITINGS
SET DEFINE OFF;
|
|
|
