The previous chapter described how to retrieve data from tables with SELECT. 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.
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.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40