What is the difference between anonymous block and named blocks?

3 Answers  

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

---

What is compilation error in pl sql?

0 Answers  

---

What does varchar include?

0 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

What is the use of non clustered index?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Can u create a primary key with out unique index.

8 Answers  

---

How is indexing done in search engines?

0 Answers  

---

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---