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 is julian date in oracle

2 Answers  

---

What are the packages in pl sql?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

How does a trigger work?

0 Answers  

---

what are the different tables present in mysql? : Sql dba

0 Answers  

---

What is column?

0 Answers  

---