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

Difference between oracle's plus (+) notation and ansi join notation?

549


WHAT IS ecc 6.0

1631


What is the minimum client footprint required to connect c# to an oracle database?

541


How to change program global area (pga) in oracle?

560


How do you tell what your machine name is and what is its IP address?

1483






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

517


What are the database administrators utilities available?

558


Explain parameter file in oracle.

554


What is a partition in oracle?

521


What is columnar storage what is the advantage?

523


How can I see all tables in oracle?

523


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)

1785


types of indexes and the rationale behind choosing a particular index for a situation.

1953


What is a named program unit?

558


How to use values from other tables in update statements using oracle?

538