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  

---

What are reports usually used for?

0 Answers  

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

Can you inner join the same table?

0 Answers  

---

What is the difference between function and procedure in pl/sql?

0 Answers  

---

how to write date and time literals? : Sql dba

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

What is the difference between partitioning and sharding?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

Which is better join or subquery?

0 Answers  

---

Does inner join remove duplicates?

0 Answers  

---