====== Tabelle Pizzazutaten befüllen ======
//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.\\
<code sql>
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);
</code>