What are the advantages of embedded query language, Database Management System

Assignment Help:

What are the advantages of embedded query language? Give an example of an embedded SQL query.

Embedded query language - SQL could be implemented within two ways. It can be used interactively or embedded within a host language or through using API. The use of SQL commands inside a host language (e.g., C, Java, etc.) program is known as embedded query language or Embedded SQL. While same capabilities are supported for a variety of host languages, the syntax sometimes varies. A few of the advantages of embedded SQL are:

SQL statements could be used wherever a statement in the host language is permitted.  It merges the strengths of two programming environments, the procedural characterises of host languages and non-procedural features of SQL.

SQL statements could refer to variables (must be prefixed through a colon in SQL statements) described in the host program. Special program variables (known as null indicators) are used to assign and retrieve the NULL values to and from the database.

The facilities available by the interactive query language are also automatically available to the host programs. Embedded SQL along with host languages could be used to accomplish extremely complex and complicated data access and manipulation tasks.

Example: The subsequent Embedded SQL statement within C inserts a row, whose column values are based on the values of the host language variables holds in it.

 EXEC SQL

 INSERT INTO Sailors VALUES (:c_sname, :c_sid, :c_rating, :c_age);


Related Discussions:- What are the advantages of embedded query language

Name the three major database in oracle, Name the three major set of files ...

Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

Define view? how it is related to data independence, A View may be defi...

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Discuss the problem of spurious tuples, Discuss the problem of Spurious tup...

Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

What is abstraction, What is abstraction? Abstraction in the object ori...

What is abstraction? Abstraction in the object orientation is a idea that provide opportunity to express necessary properties of object without providing much details of the im

Explain the disadvantages of using dbms, Explain the disadvantages of using...

Explain the disadvantages of using DBMS There could be a few disadvantages of using DBMS. As DBMS requires computers, we have to invest a good amount in acquiring the hardwa

Schema, difference between internal schema and external schema in DBMS

difference between internal schema and external schema in DBMS

Cataloguing, differences between a classified catalog and a dictionary cata...

differences between a classified catalog and a dictionary catalog

What is meant by log-based recovery, What is meant by log-based recovery? ...

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Many-to-many relationship, Many-to-many : Entities in A and B are related w...

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd