3.8 Case 4: Write Capabilities

Demonstration using write capabilities and the DELETE, UPDATE, and INSERT statements.

Case 4 is split into three cases and demonstrates the following:

• DELETE Statement
  Demonstration using write capabilities and the DELETE statement.
• UPDATE Statement
  Demonstration using write capabilities and the UPDATE statement.
• INSERT Statement
  Demonstration using write capabilities and the INSERT statement.

3.8.1 DELETE Statement

Demonstration using write capabilities and the DELETE statement.

Case 4a demonstrates bind values and subselect. All employees in department 20 and one employee, WARD, in department 30 are deleted.

3.8.2 UPDATE Statement

Demonstration using write capabilities and the UPDATE statement.

Case 4b provides an example of a simple UPDATE statement. In this example, employees are given a $100 a month salary increase.

3.8.3 INSERT Statement

Demonstration using write capabilities and the INSERT statement.

Case 4c is an example of a simple insert statement that does not provide information for all columns.