Answer Posted / ajit

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

What is ADDM Advisor in Oracle?

1158

---

How to update values in a table in oracle?

1001

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1983

---

What privilege is needed for a user to create views in oracle?

1024

---

Explain the use of indexes option in exp command.

1121

---

What is the Tune Query

2269

---

How to call a stored function with parameters?

1011

---

How to shutdown your 10g xe server from command line?

1067

---

Explain about functional dependency and its relation with table design?

992

---

What is SQL access advisor in Oracle?

1178

---

What is the best way to do multi-row insert in oracle?

1049

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2171

---

How can we find out the current date and time in oracle?

1079

---

When do you get a .pll extension in oracle? Explain its importance

1017

---

Please explain joins in oracle?

1049

---