5.6. Embedded Structured Query Language (SQL)

We have looked at a wide range of SQL query constructs in the previous sections, wherein SQL is treated as an independent language in its own right. A RDMS supports an interactive SQL interface through which users directly enter these SQL commands. However, in practice, often we need a greater flexibility of a general-purpose programming language such as integrating database application with graphical user interface. This is in addition to the data manipulation facilities provided by SQL. To deal with such requirements, SQL statements can be directly embedded in procedural language (that is, program’s source code such as COBOL, C, Java, PASCAL, FROTRAN, PL/I and so on) along with other statements ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.