For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Table used - Table_contract
Fields used - Net_amount,start_date,end date
I have to annualize the NET_AMOUNT if (END_DATE MINUS START_DATE) > 1 YEAR
How do I calculate this in SQL?