Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96942 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / keshavenas
Basically join's are three type's those are :
1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.Full outer join
d.Self join
3.Non-equi join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What operating systems are supported by oracle database 10g xe?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How would you begin to troubleshoot an ORA-3113 error?
How to compare dates in oracle sql?
How many file formats are supported to export data?
What happens to the current transaction if the session is ended?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Explain compound trigger in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is save point in oracle database?
What is the parameter mode that can be passed to a procedure?
How to bring a tablespace online?
Is the After report trigger fired if the report execution fails ?
What is a nvl function? How can it be used?
