2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

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  

---

How many types of triggers are there in pl sql?

0 Answers  

---

What is a table partition?

0 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

what is text? : Sql dba

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

What is percent sign in sql?

0 Answers  

---

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

How do I run a query in pl sql developer?

0 Answers  

---