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 are the logical operations?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
What is the difference between PFILE and SPFILE in Oracle?
ABOUT IDENTITY?
Why do you create or replace procedures rather that drop and recreate.
Explain about functional dependency and its relation with table design?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
what is the difference between rollback & commit? can a foreign key has null value?
What are a collation and state the different types of collation sensitivity?
How to export your own schema?
What is a nested table?
Explain the use of compress option in exp command.