The join defined by the default data link is an outer join
yes or no ?
Answer / meenakshi
No its not outer join
but it is an equi/natural join
| Is This Answer Correct ? | 6 Yes | 0 No |
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
Please explain compound trigger in oracle?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
what is foreign key?
How to create a new oracle data file?
What are the different pseudo commands? Explain in general?
What is the max number of columns in an oracle table?
What are synonyms used for ?
Can a Tablespace hold objects from different Schemes ?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
What is the difference between implicit index and explicit index?