Answer / Arunesh Ranjan

Creating an identity column in a table automatically assigns unique values to each new row as it is inserted into the table. This can be useful for primary key or auto-increment purposes.

What are the restrictions in a oracle read only transaction?

1 Answers  

---

How to use an explicit cursor without open statements?

1 Answers  

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

how to find the n'th highest salary from emp ?

10 Answers  

---

What is open database communication (odbc) in oracle?

1 Answers  

---

What is the difference between truncate & delete command?

1 Answers  

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

What happens to the current transaction if the session is ended?

1 Answers  

---

how to get last monday of a month?

2 Answers   Multifonds,

---

How to commit the current transaction in oracle?

1 Answers  

---

What is a data lock in oracle?

1 Answers  

---

What is Virtual Private Database in Oracle?

1 Answers   MCN Solutions,

---