Answer Posted / shriram2012

SQL> select * from quest;

Cityno cityname mails
---------- -------------------- ----------
1 bangalore 8km
2 hsr layout 20km
3 mejistic 30km
4 jayadeva 55km
5 itpl 80km
6 hebbal 115km

6 rows selected.

SQL> with data as (
2 select level as lvl,lag(level,1,0) over(order by level) as pre_lvl
3 from dual
4 where mod(level,50) = 0
5 connect by level <=150)
6 select count(cityno),pre_lvl||'-'||lvl
7 from quest
8 ,data
9 where to_number(replace(mails,'KM',0))/10 between pre_lvl and lvl
10 group by lvl,pre_lvl;

How many types of functions are there in sql?

899

---

What is a file delimiter?

1016

---

What is blind sql injection?

992

---

What is the use of non clustered index?

930

---

What packages(if any) has oracle provided for use by developers?

5719

---

What do you mean by “trigger” in sql?

1019

---

What is java sql package?

1026

---

how many triggers are allowed in mysql table? : Sql dba

997

---

Why do we create views in sql?

1055

---

Define the select into statement.

997

---

What is a Mapplet?

1058

---

What are the advantages of pl sql over sql?

964

---

What does where 1/2 mean in sql?

1012

---

what is cross join? : Sql dba

941

---

what is index? : Sql dba

946

---