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!

rtrim in where clause not returning correct data

Cathy LeeOct 27 2011 — edited Oct 27 2011

A select statement specifying

where rtrim(field_name) <> ''

is not returning any rows even though there is data on the table with field_name not blank.
If this particular where clause is omitted the data is returned and rtrim(field_name) is populated correctly.

This is occurring across different tables and in both 10.2.0.4 and 11.2.0.1 databases. I can't find any references to this being a bug.

Has anyone else come across this ? Can anyone explain why this is happening please ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2011

Added on Oct 27 2011

#11g, #data, #database, #dba, #query

2 comments

594 views