What are joins..how many types of joins are there?
- 29 Answers
- 76510 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / mouli
Joins allows you to read or report the data from more than 1 table. There are four types of joins are there..
1) equi join or inner join or natural join
2) non equi join
3) outer join
a)left outer join
b)right outer join
c)full outer join
4) self joins
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain cascading triggers.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Please explain compound trigger in oracle?
What is the max number of columns in an oracle table?
why dont we assign not null constraint as table level constraint.
Explain rename?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is a schema in oracle?
What is a connect identifier?
Why is oracle so popular?
What is the quickest way to fetch the data from a table?
What is ceil and floor in oracle?
What do you understand by database schema and what does it hold?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Write a syntax for update query in oracle?
