Different Result for Same Query

Hi,

In our DB(version 12.1.0.2) we are facing issue, below is the description.

1. We have single query which is giving different result while running. Query scenario,

Select count(1) from <table> where column_name = 'XYZ' -- this is original query

when i am giving space between select and count

Select   count(1) from <table> where column_name = 'XYZ'

This query is giving different count.

I was thinking about flush Result_cache. Is it be fine? or need to delete dependency?

Thanks,

BR