Answer Posted / apoorva garg

cityno cityname mails
1 BANGALORE 8KM
2 HSR LAYOUT 20KM
3 MEJISTIC 30KM
4 JAYADEVA 55KM
5 ITPL 80KM
6 HEBBAL 115KM

create table city(name varchar2(10), miles number);
insert into city values('bangalore',8)
insert into city values('hsr',20)
insert into city values('majestic',30)
insert into city values('jayadeva',55)
insert into city values('itpl',80)
insert into city values('hebbal',115)

DISTANCE NO.OFCITY
0-50KM 3
51-100KM 2
101-150KM 4


select * from city


select count(miles),miles
from
(select name,
CASE
WHEN (miles>=0 and miles <=50) THEN '0-50KM '
WHEN (miles>=51 and miles <=100) THEN '51-100KM '
WHEN (miles>=101 and miles <=150) THEN '101-151KM '
END miles
from city)

group by miles

What are local and global Indexes and where they are useful.

1495

---

What is meant by temporal data?

1005

---

What is cursor and why it is required?

1256

---

Can we create clustered index without primary key?

1002

---

Mention what is the plv (pl/vision) package offers?

1164

---

What trigger means?

1036

---

What is server name sql?

1208

---

What is the limitation on the block size of pl/sql?

1042

---

What is mutating sql table?

1160

---

What are the advantages of pl sql?

1167

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1192

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1226

---

Determine if oracle date is on a weekend?

1091

---

how to convert numeric values to character strings? : Sql dba

1162

---

how can we submit a form without a submit button? : Sql dba

1037

---