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
- 10074 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
What is an oracle wallet?
What is difference between truncate and delete?
What is recovery manager(rman) backup in Oracle?
Explain integrity constraints?
what are the default admin accounts in Oracle 10g ?
What do you mean by a tablespace?
Can we save images in a database and if yes, how?
How to retrieve the count of updated rows?
> 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 the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the use of constraints option in exp command.
How do I limit the number of oracle database connections generated by weblogic server?
What are the various constraints used in oracle?
What happens to the current transaction if the session is killed?
