Database Reference
In-Depth Information
Types of Data Manipulation Language:
Procedural DML
It is also called record-at-a-time or low-level DML. It must be embedded in a
programming language. It searches for retrieves individual database records. Looping
and other constructs are used by host programming language to retrieve multiple records
from databases.
Non-procedural DML
It is also called set-at-a-time or high-level DML. It can be used as a stand-alone
query language or can be embedded in a programming language. It Searches for and
retrieves information from multiple related database records in a single command.
2.7.3 Data Control Language
Data control language (DCL) is used to control user access to database and specific data
within it.
Examples of DCL:
Grant: Gives privilege or role to a user.
Revoke: Take privilege or role back from a user.
2.8 Interfaces
These are different ways to connect with database system.
2.8.1 Stand alone query languages interfaces
The application poses with the help of SQL, a query language, a query to the database sys-
tem. There, the corresponding answer (result set) is prepared and also with the help of SQL
given back to the application. This communication can take place interactively or be em-
bedded into another language.
