Thursday, May 29, 2008

Oracle/SQL Tutorial

The Oracle / SQL tutorial provides a detailed introduction to the language of SQL and Oracle Relational Database Management System. For more information about Oracle and SQL can be found on the website www.db.cs.ucdavis.edu / dbs.

Many tasks of data management, however, occur in engineering applications and sophisticated these tasks are too complex to be dealt with by such an interactive tool. Typically, the data are produced and handled calculation in the complex application programs that are written in a third-generation language (3GL) and which, therefore, need an interface with the database system. In addition, a majority of existing data-intensive engineering applications are written previously using a programming language imperative and now we want to use the functionality of a database system, which requires an easy to use l 'programming interface to the database system. Such an interface is provided in the form Embedded SQL, SQL integration in various programming languages such as C, C + +, Cobol, Fortran etc. Embedded SQL provides programmers implementing an appropriate way to combine the power of calculating a programming language with data manipulation and management capabilities of the declarative language SQL.

Since all these interfaces have comparable features in the following situations, we describe the integration of SQL in the programming language C. For this, we base our discussion on the Oracle interface to C, called Pro * C. The emphasis in this section is placed on the description of the interface, not on the introduction of the programming language C.

Download Oracle/SQL Tutorial

No comments: