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

How to define an anonymous procedure without variables?

1111

---

How to call a stored function with parameters?

1049

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1691

---

How do I spool in oracle?

1014

---

What is execute immediate in oracle?

1023

---

What is the disadvantage of User defind function?

2296

---

What are joins, explain all types of joins?

2299

---

How to login to the server without an instance?

1166

---

Explain a segment?

1093

---

How do we create privileges in oracle?

1050

---

How to use "if" statements on multiple conditions?

1174

---

What is oracle datasource?

993

---

What are the ways tablespaces can be managed and how do they differ?

2373

---

How do I start tns listener?

1051

---

How to define an oracle cursor variable?

1034

---