1
edit
Changes
→DML Statements (INSERT INTO)
1. AREA<BR>
<pre>
INSERT ALL
INTO 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(5001,'Kitsilano','Henry Hudson Elementary School','St George School','Kitsilano Secondary School','Very well-off area.')
SELECT * FROM DUAL;
</pre>
<BR>
2. AGENCY<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
<BR>
3. PROPERTY<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre><BR>
4. SINGLE<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
<BR>
5. CONDO<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
<BR>
6. OUTLET<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
<BR>
7. ADVERTISEMENT<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
<BR>
8. CLIENT<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
<BR>
9. DEED<BR>
<pre>
INSERT ALL
INTO VALUES()
INTO VALUES()
SELECT * FROM DUAL;
</pre>
==== CREATE VIEW ====
