I am having a table in the following manner.I am having yearmonth till 202012 and from 201005 to 202012 I am having activeflag,tablename1,tablename2,tablename3,tablename4 as zero.
This table needs to be update before runing the package.Before I load data for tablename1 for 201005 I need to update that 201005 for tablename1 to 1 and activeflag to 1 and I need to update the 201002 tablename1 to zero.and when I load data for 201006
I need to update first that active flag =1 for 201006 and tablename1 to 1 for 201006 and then Update 201003 tablename1 to zero.i.e in tablename1 at a given time i need to see only 3 (yearmonth)=1 and update the first non zero record to
zero.similary i need to update other tables also.
yearmonth Activeflag tablename 1
tablename2 tablename 3 tablename4
201001 0 &nb
View Complete Post