Working with Data

---

This chapter deals with manipulating the data in tables with the statements:

• INSERT for inserting new rows into tables
• UPDATE for updating rows
• DELETE for deleting rows from tables
• CALL for manipulating data by executing procedures.

Access Privileges

You must have the appropriate access privileges on the relevant table(s) in order to use INSERT, UPDATE or DELETE.

In addition, the table itself must be updatable. All base tables are updatable, but some views are not, see Updatable Views.

In order to make a CALL you must have EXECUTE privilege on the procedure.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se