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 is the use of double ampersand (&&) in sql queries?

0 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

Why do we use procedures in sql?

0 Answers  

---

Can we rollback truncate?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

Why we use join in sql?

0 Answers  

---

What is a database trigger?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Explain the the update statement in sql?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

What is %rowtype in pl sql?

0 Answers  

---