DEVFYI - Developer Resource - FYI

What are ORACLE PRECOMPILERS?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

514. What are ORACLE PRECOMPILERS?

Using ORACLE PRECOMPILERS, SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA. The Precompilers are known as Pro*C,Pro*Cobol,... This form of PL/SQL is known as embedded pl/sql,the language in which pl/sql is embedded is known as the host language. The prcompiler translates the embedded SQL and pl/sql ststements into calls to the precompiler runtime library.The output must be compiled and linked with this library to creater an executable.

(Continued on next question...)

Other Interview Questions