What is a read only transaction in oracle?

0 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

What is COST-based approach to optimization ?

5 Answers  

---

material view and view disadvantages?

0 Answers  

---

What is procedure overloading in oracle?

0 Answers  

---

How to retrieve values from data fields in record variables?

0 Answers  

---

Define the terms primary key foreign key and also the difference between primary and the unique key

2 Answers  

---

Can we call a trigger inside a function and function inside a trigger? Give example.

1 Answers   Metric Stream,

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

0 Answers  

---