Answer Posted / mukesh

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

How to get last row id?

941

---

How to create lov dynamically at runtime & attach to text field?

1099

---

How to execute a stored program unit?

1005

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1981

---

How to export data with a field delimiter?

971

---

what is meant by magic query

2137

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2262

---

How to check the server version in oracle?

1035

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

---

What are joins, explain all types of joins?

2221

---

How to export your connection information to a file?

1076

---

What is translate in oracle?

1051

---

11. Display the client number and name and the client number and name of the person who referred that client.

2278

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1291

---

Oracle

2321

---