What is the use of stored procedures?

0 Answers  

---

What is oracle and pl sql?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

Which constraints we can use while creating database in sql?

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

---

What is crud sql?

0 Answers  

---

what are the limitations of identity column? : Transact sql

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

Can a table contain multiple foreign key’s?

0 Answers  

---

What is the purpose of the sql select top clause?

0 Answers  

---

What is the main difference between sql and pl/sql?

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,

---