What is cursor and why it is required?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

What is normalization in sql?

0 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

What does bitemporal mean?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

---

What are the operators in sql?

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

How to know the last executed procedure?

0 Answers  

---