Answer Posted / mukesh

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

What is a lookup table in oracle?

1024

---

What is the sql query to concatenate column values from multiple rows in oracle?

1103

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2041

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2270

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

---

How will you identify oracle database software release?

1058

---

What happens if the update subquery returns multiple rows?

1170

---

How to use "in" parameter properly?

1119

---

What is index-organized table in Oracle?

1118

---

How to view the tablespaces in the current database?

1026

---

What are the components of logical database structure in oracle database?

1136

---

why dont we assign not null constraint as table level constraint.

2797

---

How to connect ms access to oracle servers?

1057

---

Can a parameter be passed to a cursor?

1180

---

Is java required for oracle client?

1047

---