Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

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,

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers   HCL,

---

How to start your 10g xe server?

0 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

---

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

---

How to export your connection information to a file?

0 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

What is tns service name?

0 Answers  

---

What is the difference between substr and instr?

0 Answers  

---

what is IDE,DMV in sql server?

0 Answers  

---

What is a SNAPSHOT ?

1 Answers  

---