Answer Posted / farrukh shaikh

select empid,
salary,
sum(salary) over(order by empid rows unbounded
preceding) composite_sal from (select 101 EmpID, 1000
Salary
from dual
union all
select 102, 2000
from dual
union all
select 103, 3000
from dual
union all
select 110, 5000 from dual)

what is the scripts in data base?

2127

---

What do you mean by cdb and pdb in oracle 12c?

1040

---

What is a package in oracle?

1081

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5321

---

How to run create database statement again?

1127

---

What are the general rules on data consistency?

989

---

What are internal user account in oracle?

993

---

How to get the Installed Oracle Version Information ?

1110

---

How to define a sub function?

1112

---

Can you have more than one content canvas view attached with a window ?

2314

---

Explain what are the type of synonyms?

1095

---

What is difference between truncate and delete?

1018

---

is there a tool to trace queries, like profiler for sql server?

1131

---

Difference between inner join vs where ?

1012

---

Differentiate between function and procedure in oracle.

1051

---