Answer Posted / janani

select '0-50' distance, count(*) No.ofcity from table
where mails between 0 and 50
union
select '51-100' distance, count(*) No.ofcity from table
where mails between 51 and 100
union
select '101-150' distance, count(*) No.ofcity from table
where mails between 101 and 150

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1005

---

What do you know by pl/sql cursors?

1114

---

What are stored procedures used for?

1013

---

what are the advantages and disadvantages of views in a database? : Sql dba

1047

---

How many scalar data types are supported in pl/sql?

1069

---

what is online transaction processing (oltp)? : Sql dba

1004

---

is it possible to pass an object or table to a procedure as an argument?

1144

---

What are few of the schema objects that are created using PL/SQL?

1051

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2273

---

What are the various levels of constraints?

1133

---

what is the difference between primary key and unique key? : Sql dba

1045

---

How to call a javascript function from pl sql?

1150

---

Explain the the delete statements in sql?

1078

---

Differentiate between syntax and runtime errors.

1199

---

Define select, insert, create, delete, update, drop keywords

1057

---