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

What happens to the data files if a tablespace is dropped?

0 Answers  

---

List out the types of joins.

0 Answers  

---

Explain mutating triggers.

0 Answers  

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

am completed mca2011 how get certification in oracle

1 Answers  

---

---

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

6 Answers   Polaris,

---

What is an Oracle sequence?

1 Answers  

---

What is autonomous transaction?

6 Answers  

---

How many types of tables are there in oracle?

0 Answers  

---