Hi Team,
I got an issue where table contains data but i'm not able to query that i.e when i'm using '=' it is not returning any data. But when i give like operator then it is working.
But the datatype of column is number and data existing also number only.
select * from event_audit_t where obj_id0 = 309464144709472611; --> not providing results
select * from event_audit_t where obj_id0 like 309464144709472611;--> working
select * from event_audit_t where obj_id0 <= 309464144709472611; --> working
select * from event_audit_t where obj_id0 > 309464144709472611; --> not working
Even i have updated obj_id0 with to_number still not working.
update event_audit_t set obj_id0 = to_number(obj_id0);
Kindly help me on this.
Thanks
Lakshmoji