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)

Explain an extent?

1051

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2199

---

what is the use of system.effective.date variable in oracle?

1056

---

How to define a cusotmer as a supplier in ORACLE R12

2170

---

What is tns name?

928

---

Query to retrieve record for a many to many relationship ?

2460

---

List out the types of joins.

1083

---

What is the difference between alert log file and tarce file ?

2099

---

What are the different oracle database objects?

1032

---

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

1008

---

How to sort the query output in oracle?

969

---

What happens if variable names collide with table/column names?

1105

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1936

---

How to save query output to a local file?

970

---

What exactly do quotation marks around the table name do?

918

---