Oracle compare string -

i have strange issue in oracle never seen before....

i have following insert select statement

insert table2 (     key_field,value ) select         key_field, case when type ='s' 100 else 1 end  view1 key_field=1

when run select part 100 second field, if run insert select statement 1 in table2 .

if include field type on insert, 100

if use "case when type like 's' 100 else 1 end" 100 in table2 (correct answer)

anyone has idea why first select insert statement not working?

thank you!

Naan