Explain parameter file in oracle.

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

What a SELECT FOR UPDATE cursor represent.?

1 Answers  

---

Is the After report trigger fired if the report execution fails ?

0 Answers   Oracle,

---

How to define an anonymous block?

0 Answers  

---

---

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

---

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.

3 Answers  

---

Explain what are synonyms used for?

0 Answers  

---

How do we switch from init.ora file to asp file?

2 Answers  

---

definition of cluster and non-clustered index?

0 Answers   CSS,

---

Explain how are indexes update?

0 Answers  

---

Difference between open_form and call_form in oracle.

0 Answers  

---