{{ kurs:cyberpizza.gif}} ====== Tabellen 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.\\ ===== Speisekarte ===== INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Margherita', 'mit Käse und Olive', 6.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Salami Extra', 'mit Käse und extra vielen Salamischeiben', 7.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Cardinale', 'extra viel Schinken', 7.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Alaska', 'Käse, extra viel Thunfisch und frischen Zwiebel', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'California', 'Tomatenscheiben, Broccoli, Mais, Champignon', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Quattro Stagione', 'Champignons, Schinken, Artischocken', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Rusticana', 'Käse, Speck, Mais und milden Pfefferoni', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Hawaii', 'Käse, Schinken und Ananas', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Provenziale', 'Käse, Schinken, Mais und milden Pfefferoni', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Verde', 'Käse, Spinat, Schafskäse und Knoblauch', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Al Capone', 'Käse, Salami, Mais und milden Pfefferoni', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Quattro Formaggio', 'Gorgonzola, Schafskäse, Camembert u. Pizzakäse', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Calzone', 'gefüllter Pizzateig: Schinken, Champignons, Artischocken', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Lucifer', 'Salami, Pfefferoni, Knoblauch und Tabasco', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Mexicana', 'Käse, gegrillter Hühnerbrust, Tomatenscheiben, Mais und frischem Paprika', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Western Barbecue', 'Käse, Barbecuesauce, Speck, Mais und frischem Paprika', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Texas', 'Käse, Bratkartoffeln, knuspriger Speck und frischen Zwiebeln', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Bombay', 'Käse, gegrillte Hühnerbrust, Ananas, Rosinen auf pikant scharfer Currysauce', 8.49); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'New York', 'Käse, saftiger Schinken, Thunfisch, Champignon und frischer Spinat', 8.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Pepsi Cola', '0,5 l', 1.79); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Seven Up', '0,5 l', 1.79); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Coca Cola', '0,5 l', 1.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Coca Cola Light', '0,5 l', 1.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Vöslauer prickelnd', '0,5 l', 1.39); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Eistee Pfirsich', '0,5 l', 1.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Eistee Zitrone', '0,5 l', 1.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Red Bull', '0,25 l', 2.59); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Stiegl Bier, Dose', '0,5 l', 2.20); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Valpolicella', '0,75 l', 7.99); INSERT INTO speisekarte (SK_ID, SK_Name, SK_Beschreibung, SK_Preis) VALUES (seq.nextval, 'Grüner Veltliner', '1 l', 6.99); ===== Pizzazutaten ===== 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);