How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

---

What is sql catalog?

0 Answers  

---

What is pl/sql table? Why is it used?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

What are sql injection vulnerabilities?

0 Answers  

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---

What is function and procedure?

0 Answers  

---

How many sql core licenses do I need?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---