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

ER model, coventions for displaying an ER schema as ER diagram

coventions for displaying an ER schema as ER diagram

Database design in third normal form, The following data are required to be...

The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

Create student db and execute insert query, Create Student DB and execute I...

Create Student DB and execute Insert query? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course

Determine the strong and weak entity, Determine the Strong and Weak Entity ...

Determine the Strong and Weak Entity Based on the method of foreign key, there might be arise a situation when we have to relate an entity having a primary key of its own and a

Explain data sublangauges, Explain Data Sublangauges ? Data sublanguage...

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

E-r diagram, Let us now make the E-R diagram for the student database as pe...

Let us now make the E-R diagram for the student database as per the explanation given in the previous section. We can also states the overall logical structure of a database usi

Explain the utilities which help the dba to manage database, Explain the ut...

Explain the utilities which help the DBA to manage the database? Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion wit

Hashing techniques, folding method and mid square method using visual basic...

folding method and mid square method using visual basic

Define 2nf normal form, 2NF Normal Form : A relation schema process R i...

2NF Normal Form : A relation schema process R is in 2NF if it is in 1NF and each non-prime attribute A in R is fully functionally related on primary key. Second normal form (2N

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