User Tools

Site Tools


kurs:bk_in

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

kurs:bk_in [2014/09/10 21:22]
kurs:bk_in [2014/09/10 21:22] (current)
Line 1: Line 1:
 +{{ 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 =====
 +<code sql>
 +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);
 +</​code>​
 +
 +===== Pizzazutaten =====
 +<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>​
  
kurs/bk_in.txt · Last modified: 2014/09/10 21:22 (external edit)