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
In the oracle version 9.3.0.5.0, what does each number shows?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
how to handle exceptions in post production
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Write a syntax for update query in oracle?
what is the syntax of DELETE command?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How many anonymous blocks can be defined?
hai, when to use char and varchar2....?
How to check database size in Oracle?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?