Exploring the Power and Flexibility of Dynamic and Embedded SQL

    What is SQL? SQL also referred to as Structured Query Language is capable of doing a lot more than just query a database. The most effective query language that is commercially offered is SQL. It makes use of algebra, calculus constructs in combination. It is capable of defining the structure of the data, modifying the data in the database etc. SQL consists of different divisions: • Data-definition language (DDL). Commands to define relational schemas, to delete as well as to modify relational schemas are provided by SQL. • Interactive data-manipulation language (DML). A query language which depends upon relational algebra as well as tuple relation calculus. Commands for inserting tuples in the database, for deleting tuples, and modifying tuples in the database. • Transaction control. Commands for specifying the start and end of transactions are also provided by SQL.   • Embedded and Dynamic SQL. These specify how SQL commands can be embedded within ef...