Answer Posted / ajit

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

What are the restrictions on external table columns?

1055

---

What is a lookup table in oracle?

974

---

What is the difference between $oracle_base and $oracle_home?

1091

---

What is an oracle database?

1048

---

What is dynamic proxy?

1012

---

What is enter substitution variable in oracle?

1058

---

Explain about functional dependency and its relation with table design?

1018

---

What is the difference between pre-select and pre-query?

1226

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2050

---

Explain about your project and its relation to the current job position you are applying to?

1011

---

What is the data type of dual table?

997

---

How to pass parameters to procedures in oracle?

1043

---

How to experiment a data lock in oracle?

1060

---

What is Data Dictionary Cache in Oracle?

1169

---

How to retrieve data from an explicit cursor?

1064

---