What different of iner joint & outer joint with example
Answer Posted / joel
inner join will select the record that are match only. it is
just like equi join. but outer join select the record not
only the equal one but also select the not equal one.
outer join is of three type namely
right outer,
left outer and
full outer.
1) right outer join will be like below in the join condition
e.deptno(+)=d.deptno.
that is it select all the uncommon values including common
values from the table e.
2)while left outer join will be like below in the join condition
e.deptno=d.deptno(+);
it will select uncommon values including common values
from table d.
3) full outer join is as like inner join. it will select
common values only
Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is the fastest query method to fetch data from the table?
How can we find out the duplicate values in an oracle table?
In oracle there is column command, how will you explain that?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is a sub query and what are the different types of subqueries?
What is oracle latest version?
How to update values in a table in oracle?
How to rollback the current transaction in oracle?
What is parameterized cursor in oracle?
What is SQL access advisor in Oracle?
What is ASM (Automatic Storage Management) in Oracle?
What is a named program unit?
What is the usage of synonyms?
How to define an anonymous block?