Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

What is the difference between online and offline backups?

0 Answers   MCN Solutions,

---

can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,

---

How to assign values to data fields in record variables?

0 Answers  

---

What is a proxy class?

0 Answers  

---

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---

What are the different types of record groups in oracle? Explain each of them

0 Answers  

---

What is trigger associated with the timer ?

1 Answers   Oracle,

---

What is java oracle used for?

0 Answers  

---

 What are the oracle DML commands possible through an update strategy?

0 Answers   Informatica,

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---