Explain oracle instance.

0 Answers  

---

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---

How to turn on or off recycle bin for the instance?

0 Answers  

---

Can we connect to ORACLE db using Windows Authentication?

0 Answers   MCN Solutions,

---

What is a shared pool?

1 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

What is Database Trigger ?

1 Answers  

---

How to use subqueries with the in operator using oracle?

0 Answers  

---

Explain the importance of .pll extension in oracle?

0 Answers  

---