Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97065 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / tauqueer
Joins means we can join two or more then two table in
single query.
there are 3 types of join..
1. INNER JOIN.
2. OUTER JOIN.
1.Left outer join.
2.right outer join.
3.full outer join.
3. CROSS JOIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the quickest way to fetch the data from a table?
how to make an oracle object
Can select statements be used on views in oracle?
What is a parameter file in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to insert multiple rows with one insert statement in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What privilege is needed for a user to delete rows from tables in another schema?
How to define a cusotmer as a supplier in ORACLE R12
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to use "in" parameter properly?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is save point in oracle database?
What is an oracle recycle bin?
How to write a query with a right outer join in oracle?
