Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
- 1 Answers
- 1191 Views
- I also Faced
- E-Mail Answers
• INNER JOIN: Returns only matching rows from both tables.
• LEFT JOIN: Returns all rows from the left table and matching rows from the right.
• RIGHT JOIN: Returns all rows from the right table and matching rows from the left.
• FULL JOIN: Returns all rows from both tables, filling in missing values with NULLs.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we force the database to use the user specified rollback segment?
what is the syntax of DELETE command?
How to create a table index in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
what is the syntax of SELECT command?
How to view existing locks on the database?
What is flashback Query ? And Use ?
How to insert multiple rows with one insert statement in oracle?
What is recycle bin in Oracle?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What are the components of physical database structure in the Oracle database?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Oracle General 
