Skip to Main Content

SQL & PL/SQL

Announcement

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!

years to days..

2902183Mar 12 2015 — edited Mar 12 2015

Create or replace procedure year_test(var_year varchar2(20))

v_ym INTERVAL YEAR TO MONTH;

BEGIN v_ym := INTERVAL var_year YEAR TO MONTH;

dbms_output.put_line(ROUND(((( EXTRACT (YEAR FROM v_ym)) *12)   (EXTRACT (MONTH FROM v_ym))) * 30.436) || ' Days');

END;

please help me out..i could't rectify the error

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2015
Added on Mar 12 2015
5 comments
163 views