What happens to the current transaction if the session is killed?

0 Answers  

---

How can I create database in oracle?

0 Answers  

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

What happens to indexes if you drop a table?

0 Answers  

---

what are actual and formal parameters?

0 Answers  

---

Why do you use stored procedures and state some of its disadvantages?

0 Answers  

---

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  

---

How to pass parameters to procedures?

0 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

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  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

defination of bitmap index

0 Answers   NIIT,

---