Answer / bhavya

It will common records from both the table

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

what are the type of locks ? : Sql dba

0 Answers  

---

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

what is single byte over head in oracle..?

0 Answers  

---

what is the difference between blob and text? : Sql dba

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What is sap sql?

0 Answers  

---

Compare SQL and PL/SQL.

3 Answers  

---