What is Embedded SQL?
Embedded SQL is a method of running SQL statements from a high-level language like C/C++. It allows you to execute any SQL statement from an application program. The basic idea behind Embedded SQL is that you write a program in high-level language, and embed SQL statements in it using Embedded SQL. Before the program can be compiled, it must be run through the Embedded SQL preprocessor, which converts all Embedded SQL code to library calls. The resulting C program is then compiled and executed. Pro*C is an Oracle’s embedded SQL environment. Basic syntax : EXEC SQL embedded SQL statement END-EXEC There are two types of embedded SQL: static and dynamic. Dynamic SQL allows programs to construct and submit SQL queries at run time.
