What is the difference between row level and statement level trigger?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

What is the best partition size for windows 10?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What are the different ddl commands in sql?

0 Answers  

---

How do I find duplicates in the same column?

0 Answers  

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

Its possible to add more than one primary key for the table

4 Answers  

---

How do you create a unique index?

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,

---