INTERACTIVE DATA MANIPULATION LANGUAGE

 INTERACTIVE DATA MANIPULATION LANGUAGE


        It is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language.

Most SQL database implementations extend their SQL capabilities by providing imperative, i.e. procedural languages. Examples of these are Oracle's PL/SQL and IBM Db2's SQL_PL.

Data manipulation languages tend to have many different flavors and capabilities between database vendors. There have been a number of standards established for SQL by ANSI,[2] but vendors still provide their own extensions to the standard while not implementing the entire standard.

Data manipulation languages are divided into two types, procedural programming and declarative programming.

Data manipulation languages were initially only used within computer programs, but with the advent of SQL have come to be used interactively by database administrators.

Comments

Post a Comment

Popular posts from this blog

XML, JSON, and AJAX

Image
  Extensible Markup Language  (XML) - It l ets you define and store data in a shareable manner . XML supports information exchange between computer systems such as websites, databases, and third-party applications. JSON -  is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays. It is a commonly used data format with diverse uses in electronic data interchange, including that of web applications with servers. AJAX -  It is a set of web development techniques that uses various web technologies on the client-side to create asynchronous web applications. With Ajax, web applications can send and retrieve data from a server asynchronously without interfering with the display and behavior of the existing page.
Read more

EMBEDDED DATA MANIPULATION LANGUAGE

Image
  EMBEDDED DATA MANIPULATION LANGUAGE       It consists of SQL statements used to retrieve, insert, update and delete records from database tables. DML statements are the only statements that can be rolled back or recovered. Deletes specified rows from a table. Also has a special format (DELETE WHERE CURRENT OF) for embedded SQL.       A popular data manipulation language is Structured Query Language or SQL, used to retrieve and manipulate data in a relational database. With SQL, you can perform operations on the database and also use it to create a database. SQL uses specific commands like Create, Drop, Insert, etc., to carry out the required tasks.
Read more