Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97056 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / prabhat shukla
Basically there are three types of join
1.Inner join
2.Outer join
3.self join
and there are two types of join based on condition.
1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is analyze command used for?
How to execute the package in oracle?
Explain an index?
What is the difference between translate and replace in oracle?
What is redo log?
What is java oracle used for?
What is the difference between 10g OEM and 11g OEM?
Difference between the “verify” and “feedback” command?
State and explain the different types of data models?
Describe the types of sub query?
Explain oracle data types with examples?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How do we create privileges in oracle?
WHAT IS ecc 6.0
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
