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

1) Does oracle have any table which contain all the exceptions and it's code internally?

1277


What are the attributes that are found in a cursor?

639


Explain the truncate in oracle?

543


What are the differences between lov and list item?

555


How to install oracle odbc drivers?

616






How to empty your oracle recycle bin?

564


Can we create trigger on materialized view in oracle?

556


What are the different types of partitions in oracle?

494


What are the ansi data types supported in oracle?

515


Explain the use of consistent option in exp command.

546


Explain compound trigger in oracle?

542


What is the quickest way to fetch the data from a table?

560


State the difference between a primary key and foreign key?

510


What is an anonymous block?

615


What is an oracle data file?

609