Is it possible to pass parameters to triggers?

0 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

what is union, minus and interact commands? : Sql dba

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  

---

Differentiate pl/sql and sql?

0 Answers  

---

Does truncate remove indexes?

0 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---

Is pl sql better than sql?

0 Answers  

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

Why left join is used in sql?

0 Answers  

---

What is pl sql commands?

0 Answers  

---

What is left join in sql?

0 Answers  

---