How do I save a sql query?

0 Answers  

---

What is use of term?

0 Answers  

---

List the various privileges that a user can grant to another user?

0 Answers  

---

Where do we use pl sql?

0 Answers  

---

why use cursors?

5 Answers   Oracle,

---

What is cursor and why it is required?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

Does oracle use sql?

0 Answers  

---

What is a temp table?

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,

---