SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE AUTO ( REGNUM VARCHAR2(10) PRIMARY KEY, MARK VARCHAR2(10), COLOR VARCHAR2(15), RELEASEDT DATE, PHONENUM VARCHAR2(15) ) / CREATE TABLE CITY ( CITYCODE NUMBER PRIMARY KEY, CITYNAME VARCHAR2(50), PEOPLES NUMBER ) / CREATE TABLE MAN ( PHONENUM VARCHAR2(15) PRIMARY KEY , FIRSTNAME VARCHAR2(50), LASTNAME VARCHAR2(50), CITYCODE NUMBER, YEAROLD NUMBER ) / -- AUTO INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111114,'LADA', 'КРАСНЫЙ', date'2008-01-01', '9152222221') / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111115,'VOLVO', 'КРАСНЫЙ', date'2013-01-01', '9173333334') / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111116,'BMW', 'СИНИЙ', date'2015-01-01', '9173333334') / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111121,'AUDI', 'СИНИЙ', date'2009-01-01', '9173333332') / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111122,'AUDI', 'СИНИЙ', date'2011-01-01', '9213333336') / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111113,'BMW', 'ЗЕЛЕНЫЙ', date'2007-01-01', '9214444444') / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111126,'LADA', 'ЗЕЛЕНЫЙ', date'2005-01-01', null) / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111117,'BMW', 'СИНИЙ', date'2005-01-01', null) / INSERT INTO AUTO (REGNUM, MARK, COLOR, RELEASEDT, PHONENUM ) VALUES(111119,'LADA', 'СИНИЙ', date'2017-01-01', 9213333331) / -- CITY INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(1,'Москва', 10000000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(2,'Владимир', 500000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(3, 'Орел', 300000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(4,'Курск', 200000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(5, 'Казань', 2000000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(7, 'Котлас', 110000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(8, 'Мурманск', 400000) / INSERT INTO CITY (CITYCODE,CITYNAME,PEOPLES) VALUES(9, 'Ярославль', 500000) / -- MAN INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9152222221','Андрей','Николаев', 1, 22) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9152222222','Максим','Москитов', 1, 31) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9153333333','Олег','Денисов', 3, 34) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9173333334','Алиса','Никина', 4, 31) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9173333335','Таня','Иванова', 4, 31) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9213333336','Алексей','Иванов', 7, 25) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9213333331','Андрей','Некрасов', 2, 27) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9213333332','Миша','Рогозин', 2, 21) / INSERT INTO MAN (PHONENUM,FIRSTNAME,LASTNAME,CITYCODE,YEAROLD) VALUES('9214444444','Алексей','Галкин', 1, 38) /
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear