Answer Posted / senthil kumar

6. full outer join : ALL UNMATCHED DATA FROM BOTH TABLES

SELECT * FROM TABLE A FULL OUTER JOIN TABLE B ON (A.ID= B.ID)
Ex:

TABLE A
NO NAME 1 X
2 Y
5 Z

TABLE B
NO NAME 1 XX
2 YY
3 ZZ
4 AA

OUTPUT:
NO NAME NO NAME
1 X 1 XX
2 Y 2 YY
3 ZZ
4 AA
5 Z

What is serial sql?

520

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

658

---

What can I use instead of union in sql?

505

---

How do I access sql anywhere database?

491

---

Whis is not false in primary key?

973

---

---

Can we use ddl statements in stored procedure sql server?

510

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

548

---

What is a database? Explain

587

---

What is sql clause?

537

---

What does pragma mean?

500

---

How can we store rows in PL/SQL using array?

658

---

Why cross join is used?

622

---

What is procedure explain with program?

546

---

Explain the uses of database trigger.

648

---

How will you distinguish a global variable with a local variable in pl/sql?

616

---