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

Explain what are the characteristics of data files?

1136

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2103

---

What is the difference between truncate & delete command?

1236

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2147

---

What are the uses of linked server and explain it in detail?

1117

---

What is a data dictionary and how can it be created?

1238

---

What is the difference between hot backup and cold backup in oracle?

1078

---

How to define an explicit cursor in oracle?

1100

---

List the various oracle database objects?

1111

---

What is Reduced List of Values?

2244

---

How to pass parameters to procedures?

1089

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2194

---

How do I uninstall oracle client from windows?

1057

---

Whether any commands are used for months calculation? If so, what are they?

1137

---

When do we use group by clause in a sql query?

1101

---