Changes

Jump to: navigation, search

J.Y.S

324 bytes added, 16:53, 30 November 2010
DML Statements (INSERT INTO)
<pre>
INSERT ALL
INTO AGENCY VALUES(1055,'Sutton Group Regal Realty','416.875.9873')INTO AGENCY VALUES(3079,'MacDonald Realty','604.986.0231')INTO AGENCY VALUES(7024,'Royal LePage Groupe Newton','514.234.9283')
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO PROPERTY VALUES(134982,'27 King"'"s College Circle','Toronto','ON','M5S1A1',2,2,380000,1001,1055)INTO PROPERTY VALUES(149800','17 Pleasant View Dr.','Toronto','ON','M2J2H1',3,2,470000,1001, null)INTO PROPERTY VALUES(152932,'17 Barberry Pl. #1313','Toronto','ON','M8W7V4',1,1,259888,1001, null)INTO PROPERTY VALUES(495820,'776 Laurelwood Dr.','Waterloo','ON','H3A2T5',2,2,295000,3001,3079)INTO PROPERTY VALUES(500211,'409 Kelso Cr.','Cambridge','ON','H3Y7S3',3,2,485000,4001, null)INTO PROPERTY VALUES(139204,'3043 Crown St.','Vancouver','BC','U3J3M6',5,3,1398000,5001,7024)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO SINGLE VALUES(134982,3716)INTO SINGLE VALUES(149800,1005)INTO SINGLE VALUES(139204,5400)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO CONDO VALUES(152932,250)INTO CONDO VALUES(495820,320)INTO CONDO VALUES(500211,550)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO OUTLET VALUES(1000,'Toronto Star','416.923.1782','N')INTO OUTLET VALUES(2001,'Waterloo Living','519.098.9283','M')INTO OUTLET VALUES(8001,'Canadian Life','416.982.0192','W')
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO ADVERTISEMENT VALUES(134982,1000,'25-NOV-10',350)INTO ADVERTISEMENT VALUES(149800,1000,'27-NOV-10',250)INTO ADVERTISEMENT VALUES(495820,2001,'27-NOV-10',300)
SELECT * FROM DUAL;
</pre>
<pre>
INSERT ALL
INTO CLIENT VALUES(1010,'Andrew','Lee','647.978.0192','andrew11@hotmail.com', null)INTO CLIENT VALUES(1011,'Daniel','Smith','416.895.9762','dsmith@gmail.com',5010)INTO CLIENT VALUES(1012,'Olivia','Wilson','647.915.2738','oliviaorange@gmail.com', null)INTO CLIENT VALUES(1013,'Jayden','Martin','519.225.1928','jmartin@rogers.com', null)INTO CLIENT VALUES(1014,'Maria','Brown','416.182.0021','maria.brown@hotmail.com', null)INTO CLIENT VALUES(2010,'Ethan','Roy','226.289.0394','ethanrockstar@bell.com', null)INTO CLIENT VALUES(2011,'Sophia','Tremblay','647.297.2918','stremblay@gmail.com',5010)INTO CLIENT VALUES(3010,'Ryan','Wilson','604.837.1029','wilsonryan@gmail.com', null)INTO CLIENT VALUES(3012,'Luis','Jones','416.832.6771','luis7787@rogers.com', null)INTO CLIENT VALUES(5010,'Mary','Anderson','647.234.5690','andersonpink@gmail.com', null)INTO CLIENT VALUES(7010,'James','White','647.298.9182','james.white@bell.com',1010)
SELECT * FROM DUAL;
</pre>

Navigation menu