AUSGABEN DER BEISPIELLOESUNG VON AUFGABE 2 AUF BLATT 8 ====================================================== 1) (hierzu wird mal nix verraten und gezeigt!) 2) +----------+ | xxxxxxxx | <--- zensiert ;-) +----------+ | 64 | +----------+ 1 row in set (0.02 sec) 3) +------------------+----------------------+ | NAME | xxxxxxxxxxxxxxxxxxxx | <-- wieder zensiert! +------------------+----------------------+ | Nokia 6670 | 639.98 | | Nokia 6010 | 2079 | | Nokia 6820 | 2399.92 | | Nokia 7610 White | 2799.93 | | Nokia 6630 | 3032 | | Nokia 6680 | 3285 | | Nokia 6620 | 3299.9 | | Nokia N90 | 5988 | | Nokia 6680 | 7992 | | Nokia 7610 Black | 9000 | | Nokia 3100 Blue | 10791 | | Nokia 9300 | 15574 | | Nokia 9500 | 43199.46 | +------------------+----------------------+ 13 rows in set (0.00 sec) 4) +--------------+ | PHONE | +--------------+ | 617-854-9856 | | 617-521-4552 | | 617-854-8547 | +--------------+ 3 rows in set (0.00 sec) HINWEIS: Das war der Stand der Original-Datenbank! Durch Teilaufgabe 7 aendert sich das natuerlich! 5) +------------+------------+-----------+-------+-------+---------+------+-------+------+---------+-------+ | CONTACT_ID | FIRST_NAME | LAST_NAME | EMAIL | PHONE | ADDRESS | CITY | STATE | ZIP | COUNTRY | NOTES | +------------+------------+-----------+-------+-------+---------+------+-------+------+---------+-------+ | 1 | Kim | Jones | | | | | | | | M | | 2 | John | Smith | | | | | | | | | | 3 | Jane | Campbell | | | | | | | | S | +------------+------------+-----------+-------+-------+---------+------+-------+------+---------+-------+ 3 rows in set (0.00 sec) +------------+------------+-----------+-------+-------+---------+------+-------+------+---------+-------+ | CONTACT_ID | FIRST_NAME | LAST_NAME | EMAIL | PHONE | ADDRESS | CITY | STATE | ZIP | COUNTRY | NOTES | +------------+------------+-----------+-------+-------+---------+------+-------+------+---------+-------+ | 4 | Jack | Brown | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 5 | Linda | Stevens | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 6 | Greg | King | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 7 | Valerie | Williams | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 8 | Lisa | Johnson | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 9 | Jose | Hernandez | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 10 | Paul | Wong | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | +------------+------------+-----------+-------+-------+---------+------+-------+------+---------+-------+ 7 rows in set (0.00 sec) 6) +--------------------------------+ | CLASSOFWORKER | +--------------------------------+ | Private | | Self-employed-not incorporated | | Not in universe | | Local government | | State government | | Never worked | | Self-employed-incorporated | | Federal government | | Without pay | +--------------------------------+ 9 rows in set (0.04 sec) 7) (produziert keine wichtige Ausgabe) 8) +--------------+------------------+ | QTY_IN_STOCK | NAME | +--------------+------------------+ | 8 | Nokia 6820 | | 2 | Nokia 6670 | | 8 | Nokia 6630 | | 7 | Nokia 7610 White | +--------------+------------------+ 4 rows in set (0.00 sec) 9) +-----------+----------+ | TITLE | xxxxxxxx | <-- und erneut zensiert! +-----------+----------+ | CEO | 6 | | CTO | 2 | | Developer | 1 | +-----------+----------+ 3 rows in set (0.00 sec)