what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

what is the use of friend function? : Sql dba

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

Explain normalization and what are the advantages of it?

0 Answers  

---

What is materialised View?

2 Answers   IBM,

---

What is trigger types of trigger?

0 Answers  

---

What is break?

0 Answers  

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

Differentiate between pl/sql and sql?

0 Answers  

---

cursor types? explain with example programs?

1 Answers   HP,

---

How do I find duplicates in a single column in sql?

0 Answers  

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---