Interested to Buy Any Domain ? << Click Here >> for more details...
What is OCI. What are its uses?
- 1 Answers
- 3184 Views
- I also Faced
- E-Mail Answers
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 |
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how to insert data into partitioned table partition done by Range partition
How does oracle handle read consistency?
What are a collation and state the different types of collation sensitivity?
Is java required for oracle client?
Explain alias?
What are the different types of database objects?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What are the data types in oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
can a table has a column that has only view data and in other columns we can change data?
Oracle General 
