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

Query processor in database management system, Query Processor The qu...

Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form

How many levels can be viewed architecture of the database, How many levels...

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.

Problems of concurrent transactions-lost updates, Lost Updates : Suppose th...

Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):

MULTI-LIST FILE ORGANIZATION, sir, could anybody help me in getting complet...

sir, could anybody help me in getting complete information about the mentioned topic

Define data independence, Data independence seems that "the application is...

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o

Example of grant create session to mca12, Example -GRANT CREATE SESSION TO ...

Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi

Define rotational latency time, Define rotational latency time. The ti...

Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.

Explain the disadvantages of a file processing system, Explain the disadvan...

Explain the disadvantages of a file processing system? Ans: Disadvantages of File Processing Systems include: 1) Data Redundancy 2) Data Inconsistency 3) Difficult to acce

Explain function group, What is a function group? A function group is ...

What is a function group? A function group is a collection of logically related modules that share global data with every other.  All the modules in the group are contained in

What is database trigger, What is database Trigger? A database trigger ...

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

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