Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
Table structure FD_LOG_DATA ========================== ID_BC NUMBER STR_CODE NUMBER ASS_ORDER NUMBER EFFECTIVE_DATE DATE EXPIRATION_DATE DATE PROC ===== create or replace procedure fix_y2k is v_max_dt date; begin select max(expiration_date) into v_max_dt from FD_LOG_DATA; for rec in (select expiration_date from FD_LOG_DATA) loop if add_months(rec.expiration_date,1200) <= v_max_date then update FD_LOG_DATA set expiration_date = add_months(rec.expiration_date,1200); end if; end loop; end; /
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.