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

Answer Posted / guruswamy

join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins

Is This Answer Correct ?    15 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to assign data of the deleted row to variables?

585


Explain the use of record option in exp command.

541


How to create a testing table in oracle?

547


Why does for update in oracle 8 cause an ora-01002 error?

553


What is a read write transaction in oracle?

608






What do you mean by a tablespace?

566


What is a sub query? Describe its types?

550


How to create tables for odbc connection testing?

499


What is control file used for?

607


What is meant by joins? List out the types of joins.

528


What do you mean by cdb and pdb in oracle 12c?

641


Is oracle an operator?

536


What is a package ? What are the advantages of package ?

607


What is the usage of save points in oracle database?

533


Can you have more than one content canvas view attached with a window ?

1818