What are joins..how many types of joins are there?
Answer Posted / sourabh sharma
=>INNER JOIN: Return rows when there is at least one match
in both tables
=>LEFT JOIN: Return all rows from the left table, even if
there are no matches in the right table
=>RIGHT JOIN: Return all rows from the right table, even if
there are no matches in the left table
=>FULL JOIN: Return rows when there is a match in one of the
tables
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by group by clause?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to drop an index?
How to view all columns in an existing table?
What is tns service name?
How to define an external table with a text file?
How to use an explicit cursor without open statements?
what is a Nested Loop join?
State the difference between a primary key and foreign key?
Explain the use of rows option in imp command.
How to define a variable to match a table column data type?
What is Java Pool in Oracle?
Explain what are the advantages of views?
Does oracle database need java?
What language does oracle use?