What different of iner joint & outer joint with example

Answer Posted / rizwan khan

inner Join used for Display All Match Data From two or
multible table.

Outer Join :- Display All unmached data.

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is define in oracle?

571


List out the difference between commit, rollback, and savepoint?

621


What is a cursor variable?

576


Why should I use oracle database?

574


What is a Garbage Collection? and what is full recursive Garbage collection?

2389






What do you mean by a tablespace?

566


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1564


What is user managed backup in Oracle?

615


How to run create database statement again?

622


How to commit the current transaction in oracle?

578


How many types of table in Oracle?

619


Compare and contrast between sql and sql server and explain its various functions?

535


What are triggers in oracle?

561


What are the benefits of ordbms?

619


What is ceil and floor in oracle?

579