I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

How can you select unique records from a table?

0 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

What are types of exception?

0 Answers  

---

What are the different types of sql commands?

0 Answers  

---

---

Can a foreign key be a duplicate?

0 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---

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

0 Answers  

---

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,

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

---

Can cursors be part of a trigger body?

0 Answers  

---

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

---