==== DML Statements (INSERT INTO) ====
======== Sample Data ========
write sample data for each table that is separated by comma !
e1.gAREA<BR> INSERT ALLINTO AREA VALUES(1001, 'Bayview Village', 'Adrienne Clarkson Public School', 'Amesbury Middle School', 'Bayview Secondary School', 'Upper middle class to upper class neighborhood in Toronto.')INTO AREA VALUES(3001,'Laurelwood Elizabeth Ziegler Primary School','Waterloo Middle School','Saint David Catholic Secondary School','Close to University of Waterloo and many popular amenities.')INTO AREA VALUES(4001,'Silver Heights','Alison Park Primary School'.'Eastwood Middle School','King Edward Secondary School',null)INTO AREA VALUES(5001,'Kitsilano','Henry Hudson Elementary School','St George School','Kitsilano Secondary School','Very well-off area.')SELECT * FROM DUAL;<BR>
1. AREA<BR>
'''<u>NEED 3 ROWS !</u>'''<BR>
#1001, 'Bayview Village', 'Adrienne Clarkson Public School', 'Amesbury Middle School', 'Bayview Secondary School', 'Upper middle class to upper class neighborhood in Toronto.'
#
#
2. AGENCY<BR>
'''<u>NEED 3 ROWS !</u>'''INSERT ALLINTO VALUES()INTO VALUES()INTO VALUES()SELECT * FROM DUAL;<BR>###
3. PROPERTY<BR>
'''<u>NEED 6 ROWS !</u>'''<BR>INSERT ALL#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()SELECT * FROM DUAL;
4. SINGLE<BR>
'''<u>NEED 3 ROWS !</u>'''<BR>INSERT ALLINTO VALUES()#INTO VALUES()#INTO VALUES()#SELECT * FROM DUAL;<BR>
5. CONDO<BR>
'''<u>NEED 3 ROWS !</u>'''<BR>INSERT ALLINTO VALUES()#INTO VALUES()#INTO VALUES()#SELECT * FROM DUAL;<BR>
6. OUTLET<BR>
'''<u>NEED 3 ROWS !</u>'''<BR>INSERT ALLINTO VALUES()#INTO VALUES()#INTO VALUES()#SELECT * FROM DUAL;<BR>
7. ADVERTISEMENT<BR>
'''<u>NEED 3 ROWS !</u>'''<BR>INSERT ALLINTO VALUES()#INTO VALUES()#INTO VALUES()#SELECT * FROM DUAL;<BR>
8. CLIENT<BR>
'''<u>NEED 10 ROWS !</u>'''<BR>INSERT ALLINTO VALUES()INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#INTO VALUES()#SELECT * FROM DUAL;#<BR>
9. DEED<BR>
'''<u>NEED 3 ROWS !</u>'''<BR>INSERT ALL#INTO VALUES()#INTO VALUES()#INTO VALUES()SELECT * FROM DUAL;
==== CREATE VIEW ====
