Database Reference
In-Depth Information
Figure 8.9
Insert new row to STUDENT_GRADE_VIEW.
Figure 8.10
New row being inserted in STUDENT_CLASS table.
5. To see the change made to the table STUDENT_CLASS, run the following SQL
statement:
SELECT * FROM STUDENT_CLASS
6. As shown in Figure 8.10, the row is also inserted in the table STUDENT_CLASS.
7. Next, delete the newly inserted row with the following SQL statement:
DELETE STUDENT_GRADE_VIEW
WHERE StudentID = 11 AND ClassID = 1005
Search WWH ::




Custom Search