Changes

Jump to: navigation, search

J.Y.S

1,015 bytes added, 14:20, 30 November 2010
DML Statements (INSERT INTO)
<pre>
INSERT ALL
INTO VALUES(134982,3716)INTO VALUES(149800,1005)INTO VALUES(139204,5400)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO VALUES(152932,250)INTO VALUES(495820,320)INTO VALUES(500211,550)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO VALUES(1000,'Toronto Star','416.923.1782','N')INTO VALUES(2001,'Waterloo Living','519.098.9283','M')INTO VALUES(8001,'Canadian Life','416.982.0192','W')
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO VALUES(134982,1000,'25-NOV-10',350)INTO VALUES(149800,1000,'27-NOV-10',250)INTO VALUES(495820,2001,'27-NOV-10',300)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO VALUES(1010,'Andrew','Lee','647.978.0192','andrew11@hotmail.com')INTO VALUES(1011,'Daniel','Smith','416.895.9762','dsmith@gmail.com',5010)INTO VALUES(1012,'Olivia','Wilson','647.915.2738','oliviaorange@gmail.com')INTO VALUES(1013,'Jayden','Martin','519.225.1928','jmartin@rogers.com')INTO VALUES(1014,'Maria','Brown','416.182.0021','maria.brown@hotmail.com')INTO VALUES(2010,'Ethan','Roy','226.289.0394','ethanrockstar@bell.com')INTO VALUES(2011,'Sophia','Tremblay','647.297.2918','stremblay@gmail.com',5010)INTO VALUES(3010,'Ryan,Wilson','604.837.1029','wilsonryan@gmail.com')INTO VALUES(3012,'Luis','Jones','416.832.6771','luis7787@rogers.com')INTO VALUES(5010,'Mary','Anderson','647.234.5690','andersonpink@gmail.com')INTO VALUES(7010,'James','White','647.298.9182','james.white@bell.com',1010)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO VALUES(149800,1010,75,5010,352300)INTO VALUES(139204,1012,100,3010,1394000)INTO VALUES(134982,2011,50,1014,200000)
SELECT * FROM DUAL;
</pre>

Navigation menu