Answer Posted / mukesh

select empid,
salary,
sum(salary) over(order by empid rows unbounded
preceding) composite_sal from source

How to run create database statement again?

1160

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1754

---

How to count duplicated values in a column in oracle?

1050

---

How to connect to the server with user account: sys?

1024

---

How do I know if oracle is installed on windows?

931

---

How to write a query with a right outer join in oracle?

1170

---

What is Trigger in Oracle?

1178

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2132

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

---

Can you assign multiple query result rows to a variable?

993

---

What is a nvl function?

1037

---

What are the varoius components of physical database structure of oracle database?

1006

---

How to resolve name conflicts between variables and columns?

1034

---

How to login to the server without an instance?

1166

---

State and explain the different types of data models?

947

---