What are joins..how many types of joins are there?

Answer Posted / m.sivakumar

joins is a that combines the rows from two or more tables

joins are 5 types
1.cross join
2.equi join or inner join
3.outer join
4.self join
5.non_equi join

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate query output in html format?

570


What is hot backup and logical backup?

610


How to write date and time interval literals in oracle?

575


How to select all columns of all rows from a table in oracle?

590


Explain what does a control file contain?

610






How to export data to a csv file?

627


How to do a full database export?

637


Please explain joins in oracle?

549


What happens to the current transaction if the session is ended?

527


Can we use bind variables in oracle stored procedure?

490


Explain the use of grant option in imp command.

578


How to use regular expression in pattern match conditions in oracle?

577


How to connect to oracle using service name instead of sid?

553


What is an external table?

588


What privilege is needed for a user to create views in oracle?

592