1> modify qq_emp to truncated 
     

(0 rows)
  2> append to qq_emp (id = 1, fname = "John", lname = "Smith",
                       salary = 100000, sdate = "01-jan-2000") 
     

(1 row)
  3> replace qq_emp (salary = qq_emp.salary*1.1) 
     where qq_emp.id = 1 
     

(1 row)
  4> retrieve (qq_emp.all) 
     

+-------------+------+---------------+---------------+--------------------+-------------------------+
|id           |dnum  |fname          |lname          |salary              |sdate                    |
+-------------+------+---------------+---------------+--------------------+-------------------------+
|            1|      |John           |Smith          |          $110000.00|01-jan-2000              |
+-------------+------+---------------+---------------+--------------------+-------------------------+
(1 row)
  5> delete qq_emp 
     

(1 row)
  6> retrieve (qq_emp.all) 
     

+-------------+------+---------------+---------------+--------------------+-------------------------+
|id           |dnum  |fname          |lname          |salary              |sdate                    |
+-------------+------+---------------+---------------+--------------------+-------------------------+
+-------------+------+---------------+---------------+--------------------+-------------------------+
(0 rows)
End of Request