Table of Contents
delete -- delete instances from a class
delete from class_name
[ where qual ]
Delete removes instances which satisfy the
qualification, qual from the specified class. If the qualification is absent,
the effect is to delete all instances in the class. The result is a valid,
but empty class.
You must have write access to the class in order to modify
it, as well as read access to any class whose values are read in the qualification
(see change acl(l)
.
--
--Remove all employees who make over $30,000
--
delete from emp where emp.sal > 30000
--
--Clear the hobbies class
--
delete
from hobbies
drop(l)
.
Table of Contents