Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97136 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
What are the arithmetic operations?
What is a static data dictionary in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
how the indexes are stored in the Oracle Database?
Explain the use of parfile option in exp command.
How do you bind variables in oracle?
What is an oracle user account?
How many categories of data types?
How to drop an index?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How do we create privileges in oracle?
Explain the use of indexes option in imp command.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
what's query optimization and without use of IN AND Exist can we get another way data from query
Describe varray?
