Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

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,

---

How do I count rows in sql query?

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

What is acid property in a database?

0 Answers  

---

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

---

Why use triggers in sql?

0 Answers  

---

Why is %isopen always false for an implicit cursor?

0 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---