Transcription of Embedded SQL - tinman.cs.gsu.edu
{{id}} {{{paragraph}}}
Example: bankruptcy
Embedded SQL - tinman.cs.gsu.edu
CHAPTER3 Embedded SQLO racle SQL, introduced in the previous chapter, is not a language that can beused to build sophisticated database applications, but it is a very good languagefor defining the structure of the database and generating ad hoc queries. However,to build applications, the power of a full-fledged high-level programming languageis needed. Embedded SQL provides such an environment to develop applicationprograms. The basic idea behind Embedded SQL is to allow SQL statements ina program written in a high-level programming language such as C or C++.Byembedding SQL statements in a C/C++program, one can now write applicationprograms in C/C++that interact (read and write) with the database. oracle providesa tool, called Pro*C/C++, which allows for applications to be developed in the C orC++language with Embedded SQL statements.
3.1 Host Variables 95 Figure 3.1 Compatible Oracle and C data types. Oracle Data Type C Data Type char char char(N) char array[N+1] varchar(N) varchar array[N+1]
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: