Answer / prativa mishra

Because It checks the value is not null or null.

Show the two pl/sql cursor exceptions.

0 Answers  

---

What is trigger in flip flop?

0 Answers  

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

---

Why use truncate instead of delete?

0 Answers  

---

Why procedure is used in sql?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

What is a crud api?

0 Answers  

---

Is record in oracle pl sql?

0 Answers  

---