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

Answer Posted / suresh

Join are used to connect two or more tables. There are 3
types of joins. 1) Inner Join 2) Outer Join 3) Self Join

Is This Answer Correct ?    57 Yes 31 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run create database statement again?

618


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

589


What are group functions in oracle?

585


How to do clean up if create database failed?

576


How do I use os authentication with weblogic jdriver for oracle and connection pools?

577






What is the recommended interval at which to run statspack snapshots, and why?

2435


How to use "if" statements on multiple conditions?

723


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1748


Difference between the “verify” and “feedback” command?

773


How to call a stored function with parameters?

564


Explain the dml?

600


What are the system predefined user roles?

585


What is a system tablespace?

600


What happens to the data files if a tablespace is dropped?

576


Respected sir, Please send me technical questions related to oracle apps..

1379