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?
No Answer is Posted For this Question
Be the First to Post Answer
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Why use resource manager in Oracle?
What is different bet native dynamic sql and Dbms_Sql?
what is the scenario where you take the database to NoArchivelog mode?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How to use existing values in update statements using oracle?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain the features of oracle?