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  

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What is sql and its types?

0 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---

Why do we use triggers?

0 Answers  

---

What is a stored procedure ?

9 Answers  

---

What does plv msg allows you to do?

0 Answers  

---

What is raw datatype in sql?

0 Answers  

---

Why do we need view in sql?

0 Answers  

---

what is index? : Sql dba

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---