Answer / Vikas Gautam

A LEFT JOIN in Oracle is a type of join that returns all rows from the left table and matching rows from the right table. If there are no matches, NULL values are used for the right-table columns.nnHere's an example:nn`SELECT l.customer_id, l.customer_name, r.order_id FROM customers AS l LEFT JOIN orders AS r ON l.customer_id = r.customer_id WHERE r.order_id IS NULL;`nThis query returns all customers who have not placed any orders.

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

various types of joins

9 Answers  

---

how to find out largest value in a table

2 Answers  

---

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

---

State and explain the different types of data models?

1 Answers  

---

How to start your 10g xe server from command line?

1 Answers  

---

What is null value in oracle?

1 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

What is the difference between 10g OEM and 11g OEM?

1 Answers   MCN Solutions,

---

What is Database Trigger ?

1 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---