Answer Posted / ajit

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

How much memory your 10g xe server is using?

1103

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3198

---

What is the maximum limit on the number of columns in a table?

1086

---

What are a collation and state the different types of collation sensitivity?

1167

---

How to retrieve data from an cursor to a record?

1102

---

What is recovery manager in Oracle?

1055

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

---

How to get last row id?

991

---

What is the difference between a hot backup and a cold backup in oracle?

1015

---

How to connect asp pages to oracle servers?

1072

---

What operating systems are supported by oracle database 10g xe?

1034

---

Explain an extent?

1101

---

What is the oracle implicit cursor?

1062

---

Whether any commands are used for months calculation? If so, what are they?

1097

---

Differentiate between post-database commit and post-form commit?

1037

---