|
|
|
|
|
|
Data Manipulation
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.
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.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|