Answer Posted / bijaylaxmi sahoo

write sql query following source are
table name-emp_det
EmpID, Salary
101 1000
102 2000
103 3000
answer-
select t.empid,t.sal,(select sum(x.sal) from emp_det x
where x.empid<=t.empid) as com_sal
from emp_det t;
output-
empid,sal,composite_sal
101 1000 1000
102 2000 3000
103 3000 6000

What is a dead lock in oracle?

1101

---

What is bulk copy or bcp in oracle?

1103

---

Name the various constraints used in oracle?

1005

---

How to use like conditions in oracle?

1026

---

How to create an oracle database manually?

1059

---

What is an oracle wallet?

928

---

What is the use of aggregate functions in oracle?

1015

---

How to retrieve the count of updated rows?

1111

---

How to count duplicated values in a column in oracle?

1027

---

What are the general rules on data consistency?

992

---

what is Single Byte Overhead...?

2540

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1135

---

Can I create users through internet explorer in oracle 10g?

1069

---

Explain compound trigger in oracle?

1019

---

How to use select statement to count the number of rows in oracle?

1028

---