Why We use Embedded SQL?


Structured Query Language (SQL) is a non-procedural language. Although its non-procedural character gives many speciates, it has limitations. These limitations are listed below:

1. With SQL, only one command at a time can be executed. Each time an SQL command is executed, a call is made to the Relational Database Management Systems (RDBMS) resource. This adds to the data traffic in the computer network and thereby reducing the speed of data processing.
2. SQL can’t send the results of a query to a Graphical User Interface (GUI).