1> modify qq_emp to truncated 
     
     

(0 rows)
  2> insert into qq_emp (id, fname, lname, salary, sdate) 
     values (1, 'John', 'Smith', 100000, '01-jan-2000') 
     
     

(1 row)
  3> update qq_emp set salary = salary*1.1 
     where id = 1 
     
     

(1 row)
  4> select * from qq_emp 
     
     

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

(1 row)
  6> select * from qq_emp 
     
     

+-------------+------+---------------+---------------+--------------------+-------------------------+
|id           |dnum  |fname          |lname          |salary              |sdate                    |
+-------------+------+---------------+---------------+--------------------+-------------------------+
+-------------+------+---------------+---------------+--------------------+-------------------------+
(0 rows)
  7> commit 
     
     

End of Request