Give the order of sql select?

0 Answers  

---

What is the use of index in hive?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

What type of join is sql join?

0 Answers  

---

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

Define concurrency control. : Transact sql

0 Answers  

---

What is the difference among union, minus and intersect?

0 Answers  

---

What is a sql statement?

0 Answers  

---

What are the string functions in sql?

0 Answers  

---

Why is the cursor important?

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  

---