Why do we use set serveroutput on?

0 Answers  

---

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  

---

Explain aggregate functions are available there in sql?

0 Answers  

---

What are the disadvantages of not performing database normalization?

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

How can I change database name in sql?

0 Answers  

---

What is the difference between jpql and sql?

0 Answers  

---

How to read/write files from pl/sql?

0 Answers  

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

What is sharding in sql?

0 Answers  

---

What is cursor and why it is required?

0 Answers  

---