i have one table having 2 tables
period varchar2 ,
period storing values of periods like this format
'01 - 2005' ( to refer to jan 2005)
pay date is empty
how i would update all pay_date to be last date of the month
if period = '01 - 2005' then pay_date = '31-jan-05'