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 |
How to create lov dynamically at runtime & attach to text field?
types of indexes and the rationale behind choosing a particular index for a situation.
what is normalisation?what are its uses?
Can we convert a date to char in oracle and if so, what would be the syntax?
what are views?
Why does Oracle not permit the use of PCTUSED with indexes?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
How many anonymous blocks can be defined?
How to insert a record into a table?
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.
how to find find & delete duplicate rows from two different tables?
What is a dead lock in oracle?