XL 01.02.06
Ob das Komma beim Preis ein “.” oder ein “,” sein muß, hängt von der System(Oracle)-Sprache ab.
Ich hab auch nix gfunden um die Tabelle schneller (mit weniger Code) zu befüllen.
“seq” ist übrigens unsere Sequence.

INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Ananas", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Artischocken", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Basilikum", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Bolognese", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Broccoli", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Camembert", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Champignon", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Frutti di Mare", 1.45);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "gekochtes Ei", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Gorgonzola", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Gouda", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Kapern", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Knoblauch", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Mais", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Maiskölbchen", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Mozzarella", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Oliven", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Paprika", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Perlzwiebel", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Pfefferoni mild", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Pfefferoni scharf", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Salami", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Sardellen", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Schafkäse", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Schinken", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Shrimps", 1.45);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Speck", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Spiegelei", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Spinat", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Tabasco", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Thunfisch", 1.45);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Tomatenscheiben", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Zucchini", 0.73);
INSERT INTO Pizzazutaten (PZ_ID, PZ_Name, PZ_Preis)
VALUES (seq.nextval, "Zwiebel", 0.73);