😃

Manuel Puchner ManuelPuchner

😃

Hi, I'm Manuel, a young developer who loves to learn new things.

ManuelPuchner / sql uebung 14 inserts

Created April 12, 2023 09:41

	-- inserts
	---- Produkt
	insert into Ue14_Produkt (prodNr, prodBez) VALUES (1, 'Zanderfilet');
	insert into Ue14_Produkt (prodNr, prodBez) VALUES (2, 'Milchrahmstrudel');
	insert into Ue14_Produkt (prodNr, prodBez) VALUES (3, 'Pizzabrötchen');
	insert into Ue14_Produkt (prodNr, prodBez) VALUES (4, 'Chicken Nuggets');

	---- Produktpreis
	insert into Ue14_Produktpreis (prodNr, vonDatum, prodPreis) values (1, to_date('30.06.01','DD.MM.YY'), 180);
	insert into Ue14_Produktpreis (prodNr, vonDatum, prodPreis) values (1, to_date('01.01.02','DD.MM.YY'), 190);