Hi

You can insert like this

select to_date(2||'-'||'JAN'||'-'||13) from dual

insert into tablename (COLUMN123) values(to_date( column1||'-'||COLUMN2||'-'||COLUMN3))