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 |
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
what are the differen between key flexifild and discriptive fiexifild.
What do you mean by a database transaction & what all tcl statements are available in oracle?
What happens if recursive calls get out of control?
What language does oracle use?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
Explain joins in oracle?
What is different bet native dynamic sql and Dbms_Sql?
What is the difference between sharding and replication?
What are a query and state the different types of queries and their uses?
How would you optimize a slow SQL query?
master table and child table performances and comparisons in Oracle ?