KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 6682 Interview Questions


What are ORACLE PRECOMPILERS? 

Posted in Oracle Interview Questions

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.

Post Your Answer!
Send This to a Friend

← How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
What is difference between a formal and an actual parameter? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • How would you execute a SQL query in Oracle 8 ?  30.07.08

    Again, if you ever worked with Oracle, this question should be trivial for you to answer (from command prompt, of course) If you never worked with Oracle, note...

  • What is the difference between Oracle and SQL Server ?  22.07.08

    Often people in newsgroups ask about some comparison of Oracle and SQL Server. In the article below, you can find the comparison of Oracle 9i Database with SQL...

  • What are savepoint mode and cursor mode properties ? level?  06.05.08

    Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE d...

  • What are OPEN_FORM,CALL_FORM,NEW_FORM? diff ?  06.05.08

    CALL_FORM : It calls the other form. but parent remains active, when called form completes the operation , it releases lock and control goes back to the calling...

  • What is an Oracle Instance?  30.06.06

    The Oracle system processes, also known as Oracle background processes, provide functions for the user processes—functions that would otherwise be done by the...

  • How do you call other Oracle Products from Oracle Forms?  26.03.06

    Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called p...

  • What is Data Dictionary ?  16.03.06

    The DATA DICTIONARY is a comprehensive set of tables and views owned by the DBA users SYS and SYSTEM, which activates when ORACLE is initially installed, and is...

  • What are ORACLE PRECOMPILERS ?  16.03.06

    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 Prec...

  • What is Oracle Block? Can two Oracle Blocks have the same address?  08.03.06

    Oracle "formats" the database files into a number of Oracle blocks when they are first created—making it easier for the RDBMS software to manage the files and...

  • What is an Oracle Instance?  08.03.06

    The Oracle system processes, also known as Oracle background processes, provide functions for the user processes—functions that would otherwise be done by the...