Acrobat X Files

Home > Programming > Oracle Programming

Relational Application Programming Embedded SQL Programming Oracle ...

Sort Desciption:

Relational Application Programming October 23 2003 1. Programming Oracle Applications. Done in several ways. Writing interactive SQL queries in the ...

Content Inside:

Relational Application Programming Embedded SQL Programming Oracle Applications Programming in PL/SQLPage 1Relational Application Programming SQL is not computationally complete Embedded SQL (ESQL): SQL expressions embedded into programs in traditional algorithmic languages (e.g. C COBOL): host language In addition DBMSs provide proprietary languages that integrate SQL:3 Informix4GL3 Informix Stored Procedure Language (SPL)3 Oracle PL/SQL3 Microsofts Transact SQL (TSQL)1Embedded SQLLanguageCompilerExecutableProgramsource ESQLPreprocessorESQLSourceProcedureProgram withcallsProgram Application program = statements in host language interspersed with SQL requests Preprocessor replaces relational expressions by calls to compiled modules realizing relational access Result of relational requests exploited one tuple at a time in host programminglanguage impedance mismatch Static embedding: SQL statements written as part of the source program text Dynamic embedding: SQL statements composed by DBMS according to datainput by users2Relational Application Programming October 23 2003 1Programming Oracle ApplicationsDone in several ways Writing interactive SQL queries in the SQL query mode Writing programs in a host language and embedding SQL within the program3 precompiler (e.g. PROCOBOL PROC) used to link the application toOracle Writing in PL/SQL Oracles procedural language Using Oracle Call Interface (OCI) and the Oracle runtime library SQLLIB3Programming in PL/SQL Oracles procedural language extension to SQL with3 data encapsulation information hiding overloading exception handling Most heavily used technique for application development in Oracle Blockstructured language Basic units: procedures functions anonymous blocks Can contain any number of nested subblocks Declarations are local to the block and cease to exist when the block completes Structure of PL/SQL block DECLARE declarations ]BEGIN statements EXCEPTION handlers ]END;4Relational Application Programming October 23 ...

Source: cs.ulb.ac.be

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...