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 can db_files > maxdatafiles since db_files is for instance and the later is for database
where we have to use ON clause and where we have to use USING clause in JOINS
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
What are the trigger associated with image items ?
Explain the use of analyse option in exp command.
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
13. Display the second to fifth characters in each client name.
what is the difference between no rows returned and null returned?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
What is Undo Management Advisor in Oracle?
What the is the diff between local index and global index. give some example.
How to put more than 1000 values into an oracle in clause?