This code works except it's not pulling the data for call_date3, how can I get the data that's stored in this field?
select to_char (call_date, 'MM-DD-YYYY') call_date2, call_num, clientname, dept_code, staff_id, status, decode (trunc(sysdate) - trunc(to_date (call_date)), 3,'<font color=red><b>' || call_date || '</b></font>' , 5, '<font color=blue><b>' || call_date || '</b></font>', '<font color=pink><b>' || call_date || '</b></font>') call_date3
from hd_call
where call_date between '01-May-06' and '02-May-07'
and staff_id = decode ('##Param1##', 'ALL', staff_id, '##Param1##')
and status = decode ('##Param2##', 'ALL', status, '##Param2##')
and dept_code = decode ('##Param3##', 'ALL', dept_code, '##Param3##')
and not ('##Param1##' = 'ALL' and '##Param2##' = 'ALL' and '##Param3##' = 'ALL' )
[Updated on: Wed, 04 October 2006 10:18]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
