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

How do we get field detail of a table?

631


What is java oracle used for?

531


How can we find out the duplicate values in an oracle table?

616


What are the different types of database objects?

536


What is Data Dictionary Cache in Oracle?

666






Explain integrity constraint?

650


What is tns name?

549


Explain temporal data types in oracle

617


What is oracle sid?

511


What are the major difference between truncate and delete?

521


what is the difference between data migration and production migration.

1813


How to start your 10g xe server?

603


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1809


How to sort the query output in oracle?

621


What is a proxy object?

586