posted 14 years ago
Hi All,
Below is the query am using, how to apply Decode for the fields for
first_entry, second_entry.
I need selected fields prog_id,prd_no,first_entry, second_entry for prog_id='1' and prd_no='1' , if there is no values for this then I need to keep ZERO for first_entry and second_entry.
The same logic again for prog_id='1' and prd_no='2'
prog_id='1' and prd_no='3'
prog_id='1' and prd_no='4'
..
.
.
.
.
prog_id='1' and prd_no='12'
Then prog_id ='2' and prd_no='1'
prog_id ='2' and prd_no='2'
.
.
.
prog_id ='2' and prd_no='12'
like this i need to check upto prog_id='8'
So totally i need to get 96 records