What is OCI. What are its uses?



What is OCI. What are its uses?..

Answer / 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

More Oracle General Interview Questions

How to create lov dynamically at runtime & attach to text field?

0 Answers  


types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  


what is normalisation?what are its uses?

0 Answers  


Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  


what are views?

8 Answers   TCS,






Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  


A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 Answers  


How many anonymous blocks can be defined?

0 Answers  


How to insert a record into a table?

0 Answers  


5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,


how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,


What is a dead lock in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)