Interested to Buy Any Domain ? << Click Here >> for more details...
A and B are tables. x is a column. Then What is difference
between A.x = B.x(+) and A.x = B.x ?
- 7 Answers
- 9567 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / guest
the difference between A.x=B.x(+) is a outer join and
A.x=B.x is a inner join.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
master table and child table performances and comparisons in Oracle ?
How to execute a stored procedure in oracle?
How does Oracle guarantee data integrity of data changes?
How to start your 10g xe server from command line?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is an external table?
What is Undo Management Advisor in Oracle?
What are the different types of synonyms?
What do you mean by merge in oracle?
What are the original export and import utilities?
> 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?
How to establish administrator authentication to the server?
How to filter out duplications in the returning rows using oracle?
Where are the settings stored for each instance in oracle?
