Answer / sadhana

conflict serialisability
view serialisability

What is %type in pl sql?

0 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

what is the difference between granting and creating a view?

2 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

What do you understand by case manipulation functions?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

Why stored procedure is faster than query?

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

What are the types of join in sql?

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---