Answer Posted / ajit

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

How do I find my oracle client driver version?

972

---

Explain about functional dependency and its relation with table design?

954

---

What are the benefits of ordbms?

1024

---

How many file formats are supported to export data?

1139

---

master table and child table performances and comparisons in Oracle ?

2071

---

How to pass a parameter to a cursor in oracle?

1106

---

Is oracle an open source?

1021

---

How to start a specific oracle instance?

991

---

What do you understand by a database object? Can you list a few of them?

971

---

How to define a cusotmer as a supplier in ORACLE R12

2170

---

How do I limit the number of rows returned by an oracle query after ordering?

1101

---

interview questions with answer for cts

2534

---

How to test null values?

1044

---

What does sharding mean?

946

---

How to insert a new row into a table in oracle?

1096

---