retrieve (e.all) from e in EMP
retrieve (e.all) from e in EMP where e.age < 40
retrieve (e.all) from e in EMP where e.age < 40 and e.salary = 25600
retrieve (EMP.oid)
retrieve (EMP.all)
destroy EMP
retrieve (e.all) from e in Circle
retrieve (EMP.all)
retrieve (person.all)append DEPT (dname = "management", floor = 34, manager = "Leroy"
append DEPT (dname = "management", floor = 34, manager = "Leroy")
retrieve (Hercules1.oid)
retrieve (e.all) from e in STUD_EMP
retrieve (e.oid) from e in STUD_EMP
delete STUD_EMP where STUD_EMP.oid = "218840"
create EMP (name = text, salary = int4, age  = int4 , dept = char16) 
create STUD_EMP (location = point) inherits (EMP)
append EMP (name = "Joe", salary = 1400, age = 40, dept = "shoe")
append EMP (name = "Sam", salary = 1200, age = 29, dept = "toy") 
append EMP (name = "Bill", salary = 1600, age = 36, dept = "candy")
append EMP (name = "Bilal", salary = 1650, age = 36, dept = "candy") 
append EMP (name = "Sam", salary = 1200, age = 29, dept = "toy") 
append EMP (name = "Sam", salary = 1200, age = 29, dept = "toy") 
retrieve (e.all) from e in Circle
retrieve (e.all) from e in EMP where e.age < 40 and e.salary = 25600
retrieve (e.all) from e in PART
define view empdept (vsalary = e.salary, f.manager) from e in EMP, f in DEPT where f.dname = e.dept
destroy empdept
retrieve (BOEING747.oid)
retrieve (BOEING747.oid,BOEING747.all)