SQL & PL/SQL

Hi Experts,

when the time of data inserting using bulk mode, i am facing some problems like:

i have two tables say a and b

desc a
empname number
empdate varchar2(50)

desc b

empname number
empdate date


when the of inserting data into b from a i am converting second column to date using to_date() function fine....

but i have data like 00000000 in column empdate in a table,because of this it is terminating the select stmt, and 0 records inserting.

Is there any solution to load data in to table b from a without using like operator.


Thanks in advance...