What is PL/SQL table ?

6 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,

---

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

Explain the methods used to protect source code of pl/sql.

0 Answers  

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

List the different type of joins?

0 Answers  

---

Can you upgrade sql express to full sql?

0 Answers  

---

Explain character-manipulation functions?

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

How can I delete duplicate rows?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---