Can we use ddl commands in pl sql?

0 Answers  

---

What is exception? What are the types of exceptions?

0 Answers  

---

what is inline view?

15 Answers  

---

What is the difference between Union and Union all. Which is faster.

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,

---

---

Can we use delete in merge statement?

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

Does inner join remove duplicates?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

What is type and rowtype in pl sql?

0 Answers  

---

What is sql procedures and functions?

0 Answers  

---