Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98094 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / pravin
Joins are used to fetch data or information from one or
more tables and there are five types of join.
1. Inner Join
2. Outer Join
3. Self Join
4. Cross Join
5. Exception Join
| Is This Answer Correct ? | 27 Yes | 40 No |
Post New Answer View All Answers
What is hot backup and logical backup?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is max rowid in oracle?
How to define default values for formal parameters?
Explain the use of full option in exp command.
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to best split csv strings in oracle 9i?
How to check your oracle database 10g xe installation?
How to join two tables in a single query using oracle?
How to get execution path reports on query statements?
How to open and close an explicit cursor in oracle?
How to use subqueries with the in operator using oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the four Oracle system processes that must always be up and running for the database to be useable?
Explain the use of rows option in exp command.
