Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Equal to and greater than operator not working in oracle sql

3153358Feb 13 2017 — edited Feb 15 2017

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

This post has been answered by Sven W. on Feb 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2017
Added on Feb 13 2017
27 comments
6,484 views