Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Zadanie 1
- CREATE TABLE Producenci (
- IDProducenta NUMBER(5) PRIMARY KEY,
- NazwaFirmy VARCHAR(50) NOT NULL,
- Adres VARCHAR(50) NOT NULL,
- Telefon VARCHAR(15),
- Odleglosc NUMBER(10) CHECK (Odleglosc >= 0)
- );
- --Zadanie 2
- INSERT INTO Producenci VALUES(s_prod.NEXTVAL, 'Wedel', 'Warszawa', '8365432',100);
- INSERT INTO Producenci VALUES(s_prod.NEXTVAL, 'Suchard', 'Krakow', NULL, 150);
- INSERT INTO Producenci VALUES(s_prod.NEXTVAL, 'Kania', 'Zurich', '00411876123',NULL);
- --Zadanie 3
- ALTER TABLE Towary ADD IDProducenta NUMBER(5) DEFAULT 2;
- --Zadanie 4
- ALTER TABLE Towary MODIFY IDProducenta NUMBER(5) DEFAULT 2 REFERENCES Producenci(IDProducenta);
- ALTER TABLE Towary ADD FOREIGN KEY (IDProducenta) REFERENCES Producenci(IDProducenta);
- --Zadanie 5
- INSERT INTO Towary VALUES(DEFALUT, 'AAA', 15, 555);
- ALTER TABLE Producenci DROP PRIMARY KEY;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement