Answer Posted / js

SELECT R,COUNT(R) FROM
(
SELECT cityname,mail,
CASE WHEN SUBSTR(MAIL,1,INSTR(MAIL,'KM' )-1) BETWEEN 0 AND 50 THEN '0-50'
WHEN SUBSTR(MAIL,1,INSTR(MAIL,'KM' )-1) BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150' END R FROM CITY) GROUP BY R;

How many types of cursors supported in pl/sql?

1258

---

What is primary key in db?

1070

---

How to rename a column in the output of sql query?

1125

---

How does a covering index work?

1008

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1287

---

How can we store rows in PL/SQL using array?

1269

---

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

1354

---

Is clustered index a primary key?

988

---

What are all the different normalization?

1084

---

Explain the uses of control file.

1100

---

Can you load data into multiple tables at once? : aql loader

1118

---

how to fetch alternate records from a table? : Sql dba

1166

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1053

---

How do I make sql search faster?

1044

---

What is sql*loader and what is it used for? : aql loader

1249

---