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 mutating error in pl sql?

1066

---

What is a schema sql?

1226

---

how tsql statements can be written and submitted to the database engine? : Transact sql

1037

---

Why sql query is slow?

1044

---

What does truncate mean in sql?

1084

---

Does google use sql?

1007

---

What is basic structure of pl sql?

1131

---

What is a natural join?

1140

---

what are the different index configurations a table can have? : Sql dba

1042

---

Can we use view in stored procedure?

955

---

What is AUTH_ID and AUTH_USER in pl/sql ?

2236

---

How do I run a program in pl sql?

1055

---

What is fmtonly in sql?

1161

---

What is the difference between left join and right join?

990

---

What has stored procedures in sql and how we can use it?

1127

---