CREATE VIEW - Revision history

203.196.143.211 at 08:35, 18 December 2012

2012-12-18T08:35:12Z

2012-12-18T08:12:44Z

2012-12-18T08:11:49Z

2012-10-22T20:09:52Z

Reverted edits by Miacardenas (talk) to last revision by Connor

2012-10-22T08:36:58Z

2012-10-22T08:36:22Z

2012-07-17T13:56:27Z

2012-07-17T13:55:15Z

2012-07-17T11:40:14Z

2012-07-17T11:39:32Z

@@ Line 20: / Line 20: @@
 INSERT INTO games VALUES (2008,'Beijing');
 INSERT INTO games VALUES (2012,'London');
 </source>
 The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts.

@@ Line 20: / Line 20: @@
 INSERT INTO games VALUES (2008,'Beijing');
 INSERT INTO games VALUES (2012,'London');
-INSERT INTO GAMES VALUES (2008,'USA');
+INSERT INTO GAMES VALUES (2014,'USA');
 </source>
 The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts.

@@ Line 20: / Line 20: @@
 INSERT INTO games VALUES (2008,'Beijing');
 INSERT INTO games VALUES (2012,'London');
 </source>
 The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts.

@@ Line 1: / Line 1: @@
 <h1>CREATE VIEW</h1>
-<p>The table <code>games</code> shows the year and the city hosting the Olympic Games. [http://dissertations.biz/writing-service.php http://dissertations.biz/]</p>
+<p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p>
 <table>
 <caption align='center'>games</caption>
@@ Line 19: / Line 19: @@
 INSERT INTO games VALUES (2004,'Athens');
 INSERT INTO games VALUES (2008,'Beijing');
 INSERT INTO games VALUES (2012,'London');
 </source>
 The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts.

@@ Line 1: / Line 1: @@
 <h1>CREATE VIEW</h1>
-<p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p>
+<p>The table <code>games</code> shows the year and the city hosting the Olympic Games. [http://dissertations.biz/writing-service.php http://dissertations.biz/]</p>
 <table>
 <caption align='center'>games</caption>
@@ Line 19: / Line 19: @@
 INSERT INTO games VALUES (2004,'Athens');
 INSERT INTO games VALUES (2008,'Beijing');
-INSERT INTO games VALUES (2012,'London'); [http://dissertations.biz/writing-service.php http://dissertations.biz/]
+INSERT INTO games VALUES (2012,'London');
 </source>
 The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts.

@@ Line 11: / Line 11: @@
 <div class=params>schema:scott</div>
 <source lang=sql class='tidy'> DROP TABLE games;
-DROP TABLE old_games</source>
+DROP TABLE old_games;
 <source lang=sql class='setup'> CREATE TABLE games(
    yr INTEGER PRIMARY KEY,
@@ Line 23: / Line 24: @@
 In this example the VIEW old_games shows those games before 2006.
 <source lang='sql' class='def e-oracle'>
-CREATE VIEW old_games AS
+CREATE VIEW og AS
    SELECT yr,city FROM scott.games
     WHERE yr<2006;
-SELECT * FROM old_games;
+SELECT * FROM og;
 </source>
 <source lang='sql' class='def'>
-CREATE VIEW old_games AS
+CREATE VIEW og AS
    SELECT yr,city FROM games
     WHERE yr<2006;
-SELECT * FROM old_games;
+SELECT * FROM og;
 </source>
 </div>