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 to enter a new row into a table interactively?
What do database buffers contain?
what are the diffeenes between oracle 9i,oracle 10g
how to find the second highest salary in a given table????
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
How to get execution path reports on query statements?
Explain view?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
ABOUT IDENTITY?