1. User's Guide
  2. Case Studies
  3. Case 4: Write Capabilities

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.

Parent topic: Case Studies

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.

Parent topic: Case 4: Write Capabilities

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.

Parent topic: Case 4: Write Capabilities

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.

Parent topic: Case 4: Write Capabilities