what are the advantages of cursors than procedures?

2 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is pl sql script?

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  

---

Explain the difference between rename and alias?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

How many types of index are there?

0 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

Explain ttitle and btitle.

0 Answers  

---

How are functions and procedures called in PL/SQL?

0 Answers  

---

What are sql triggers used for?

0 Answers  

---