Not able to apply decode function to my query

[Kartik Tal]

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

 select prog_id,prd_no,first_entry, second_entry
from periodTable where prog_id  in ('1','2','3','4','5','6','7','8') and plnt_id='6'
and year_no='2009' and prd_no in ('1','2','3','4','5','6','7','8','9','10','11','12')  

[Vinod Tiwari]

Refer this http://www.oradev.com/decode.jsp