What is OCI. What are its uses?

Answer Posted / nishi

Oracle Call Interface is a method of accesing database from a 3GL program. Uses-- No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides

-functions to parse SQL statemets

-bind input variables

-bind output variables

-execute statements

-fetch the results

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of tables supported by oracle?

580


How to write a query with a right outer join in oracle?

621


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1831


How to pass a parameter to a cursor in oracle?

599


Can you create a synonym without having a table?

558






What is an oracle tablespace?

609


How to Truncate Table in Oracle

659


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1470


How to synchronize 2 schema's objects?

1692


How do we get field details of a table?

550


How to execute the package in oracle?

574


What are the most common interview questions on ETL Testing for experience?

599


What is a static data dictionary in oracle?

576


What types of joins are used in writing subqueries?

569


What is format trigger?

1618