SQL> SELECT * FROM Movie; TITLE YEAR LENGTH INCOLOR STUDIONAME PRO ------------------------- ---------- ---------- ---------- --------------- --- Pretty Woman 1990 119 1 Disney 999 The Man Who Wasn't There 2001 116 0 USA Entertainm. 777 Logan's run 1976 1 888 Star Wars 1977 124 1 Fox 555 Empire Strikes Back 1980 111 1 Fox 555 Star Trek 1979 132 1 Paramount 444 Star Trek: Nemesis 2002 116 1 Paramount 321 Terms of Endearment 1983 132 1 MGM 123 The Usual Suspects 1995 106 1 MGM 999 Gone With the Wind 1938 238 1 MGM 123 10 rows selected. SQL> SELECT * FROM MovieExec; NAME ADDRESS CERT NETWORTH ------------------------------ ------------------------------ ---------- ---------- George Lucas Oak Rd. 555 200000000 Ted Turner Turner Av. 333 125000000 Stephen Spielberg 123 ET road 222 100000000 Merv Griffin Riot Rd. 199 112000000 Calvin Coolidge Fast Lane 123 20000000 SQL> SELECT * FROM MovieStar; NAME ADDRESS G BIRTHDATE ------------------------------ ------------------------------ - ---------- Jane Fonda Turner Av. F 7/7/77 Alec Baldwin Baldwin Av. M 6/7/77 Kim Basinger Baldwin Av. F 5/7/79 Harrison Ford Prefect Rd. M 5/5/55 Debra Winger A way F 5/6/78 Jack Nicholson X path M 5/5/49 6 rows selected. SQL> SELECT * FROM StarsIn; MOVIETITLE MOVIEYEAR STARNAME ------------------------------ ---------- ------------------------------ Star Wars 1977 Carrie Fisher Star Wars 1977 Mark Hamill Star Wars 1977 Harrison Ford Empire Strikes Back 1980 Harrison Ford The Usual Suspects 1995 Kevin Spacey Terms of Endearment 1983 Debra Winger Terms of Endearment 1983 Jack Nicholson 7 rows selected. SQL> SELECT * FROM Ships; NAME CLASS LAUNCHED -------------------- -------------------- ---------- California Tennessee 1921 Haruna Kongo 1915 Hiei Kongo 1914 Iowa Iowa 1943 Kirishima Kongo 1915 Kongo Kongo 1913 Missouri Iowa 1944 Musashi Yamato 1942 New Jersey Iowa 1943 North Carolina North Carolina 1941 Ramillies Revenge 1917 Renown Renown 1916 Repulse Renown 1916 Resolution Revenge 1916 Revenge Revenge 1916 Royal Oak Revenge 1916 Royal Sovereign Revenge 1916 Tennessee Tennessee 1920 Washington North Carolina 1941 Wisconsin Iowa 1944 Yamato Yamato 1941 21 rows selected. SQL> SELECT * FROM Classes; CLASS TY COUNTRY NUMGUNS BORE DISPLACEMENT -------------------- -- -------------------- ---------- ---------- ------------ Bismarck bb Germany 8 15 42000 Iowa bb USA 9 16 46000 Kongo bc Japan 8 14 32000 North Carolina bb USA 9 16 37000 Renown bc Gt. Britain 6 15 32000 Revenge bb Gt. Britain 8 15 29000 Tennessee bb USA 12 14 32000 Yamato bb Japan 9 18 65000 8 rows selected. SQL> SELECT * FROM Outcomes; SHIP BATTLE RESULT -------------------- -------------------- ---------- Bismarck North Atlantic sunk California Suriago Strait ok Duke of York North Cape ok Fuso Suriago Strait sunk Hood North Atlantic sunk King George V North Atlantic ok Kirishima Guadalcanal sunk Prince of Wales North Atlantic damaged Rodney North Atlantic ok Scharnhorst North Cape sunk South Dakota Guadalcanal damaged Tennessee Suriago Strait ok Washington Guadalcanal ok West Virginia Suriago Strait ok Yamashiro Suriago Strait sunk 15 rows selected. SQL> SELECT * FROM NullExample; A B ---------- ---------- 0 10 20 0 0 0 0 10 0 20 10 10 0 10 10 10 20 20 20 0 20 10 20 20 16 rows selected.