Answer / Shubham Srivastav

No, a full outer join is not the same as a cross join. A cross join, or cartesian product, returns all possible combinations of rows from two tables without any conditions. In contrast, a full outer join returns all records when there's a match in either left or right table, filling missing values with NULL. Full outer joins can be achieved using the `FULL OUTER JOIN` clause in SQL.

What are the types of join in sql?

1 Answers  

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

What is trigger explain it?

1 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

What is a full join?

1 Answers  

---

Is it possible to create startup or shutdown trigger for on-schema?

1 Answers  

---

What is dialect in sql?

1 Answers  

---

What is a scalar value in sql?

1 Answers  

---

How can I change database name in sql?

1 Answers  

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1 Answers  

---

What is sql clause?

1 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

1 Answers  

---