return any data? If so what data is returned? And for what it's worth storing dates as varchar2 is not the very best choice IMHO.
select EMP_DOB, EMP_SATTLEMENT_DATE from PF_PERSONAL_DTL_TXN2011 WHERE PF_NUM IS NOT NULL and (emp_dob is not null or emp_sattlement_date is not null)
user7197586 wrote:You are repeating yourself. would you mind executing the query without the to_date and maybe with the additional conditions to check if emp_dob and emp_sattlement_date are really null (like I suggested a few posts above)?
execute this query in Toad it's shown error as - ORA-01858: a non-numeric character was found where a numeric was expected