What is the use of stored procedures?

0 Answers  

---

What do you mean by field in sql?

0 Answers  

---

What is sql not null constraint?

0 Answers  

---

What is difference between left and right outer join?

0 Answers  

---

How do you delete data from a table?

0 Answers  

---

how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,

---

What is the use of a view in 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,

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

what is pragma ?

1 Answers   Polaris,

---

How long it takes to learn pl sql?

0 Answers  

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---