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

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,

---

How many types of cluster table in Oracle?

0 Answers   MCN Solutions,

---

What is the sid in oracle?

0 Answers  

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

Explain oracle instance.

0 Answers  

---

What are the attributes of cursor?

0 Answers  

---

Explain the use of grant option in exp command.

0 Answers  

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,

---

7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

0 Answers  

---

Can a Tablespace hold objects from different Schemes ?

3 Answers  

---

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 Answers  

---