Answer Posted / ajit

select decode ( status, 'open', num ) open,
decode ( status, 'close', num ) close
from A;

What is the string concatenation operator in oracle?

1230

---

Can you drop an index associated with a unique or primary key constraint?

1069

---

What are the various constraints used in oracle?

1096

---

What is the exact use of Collections?

2190

---

What is a subquery in oracle?

1166

---

How to create an oracle database?

1102

---

What is the recommended interval at which to run statspack snapshots, and why?

2962

---

Explain a private synonyms?

1097

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2318

---

What are the limitations of check constraint?

1075

---

What are the common oracle dba tasks?

1201

---

Explain a synonym?

1088

---

Explain parameter file in oracle.

1081

---

What is different types of joins?

1078

---

How can we force the database to use the user specified rollback segment?

1200

---