What are inner join and outer join?

Answer Posted / omprakash.jsm

Inner join return rows from many tables where the join field and data type are equal.

outer join return rows from many tables where the join field are not equal but data type will be same.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of system.effective.date variable in oracle?

868


what is the difference between restoring and recovering?

753


Can we commit inside a function in oracle?

722


How to create a stored program unit?

788


What is meant by raw datatype?

785


What is an oracle user role?

779


What is a oracle database?

804


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1801


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

843


what are archived logs?

1935


How to resolve the ORA-39133 error in Oracle?

792


What is object data modeling?

693


Point the difference between translate and replace?

816


What are the attributes that are found in a cursor?

825


How to get maxsal , minsal, ename department wise in single query

1295