Answer Posted / anjan ghosh

create table xyz ( x varchar2(30),y varchar2(30),z number);

insert into xyz values (6 , 'HEBBAL' ,115);

select count(*) as No_of_city , '0-50' as Distance from xyz
where z between 0 and 50
union all
select count(*)as No_of_city ,'51-100' as Distance from
xyz where z between 51 and 100
union all
select count(*)as No_of_city ,'101-150' as Distance from
xyz where z between 51 and 100

What is database white box testing and black box testing?

1161

---

What is procedure and function in sql?

1047

---

What is the difference between view and stored procedure?

1003

---

Difference between table function and pipelined function?

1082

---

What is the difference between rollback and rollback to statements?

1102

---

how to escape special characters in sql statements? : Sql dba

1084

---

How to write a query to show the details of a student from students table whose

1064

---

How do I run a sql script?

1233

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

---

What is the current version of postgresql?

1129

---

What is trigger price?

1049

---

How many sectors are in a partition?

1120

---

What is online transaction processing (oltp)?

1069

---

How global cursor can be declare with dynamic trigger ?

2272

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273

---