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 pl/sql package consists of?

838

---

Is it important to partition hard disk?

744

---

What is a file delimiter?

746

---

What is the purpose of cursors in pl/sql?

798

---

Which command is used to call a stored procedure?

713

---

---

What is the location of pre_defined_functions.

841

---

How do you create a unique index?

775

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

798

---

What is tuple in sql?

732

---

what is a foreign key ? : Sql dba

789

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

705

---

What is rollback?

786

---

What are the different types of dbms?

729

---

What language is oracle sql developer?

714

---

How to process query result in pl/sql?

773

---