Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98046 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
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
Give the various exception types.
Explain how you would restore a database using RMAN to Point in Time?
How to find the duplicate rows count from employees table in oracle?
Explain index?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Why do you use stored procedures and state some of its disadvantages?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to write date and time literals in oracle?
How to display row numbers with the records?
What is an oracle tablespace?
Is postgres faster than oracle?
How to drop an index in oracle?
How can I create database in oracle?
What is Undo Management Advisor in Oracle?
Explain what are the type of synonyms?
