PL/SQL (MOSC)

MOSC Banner

Query Output not proper

edited Feb 23, 2011 1:19AM in PL/SQL (MOSC) 9 commentsAnswered
Hi,

We have query in which below part is in Where clause

nvl(fdi.end_time, sysdate) = nvl((SELECT max(end_time) from fsi_data_identity fdid WHERE fdid.description = fdi.description),sysdate)

Query doesn't returns incomplete set of records

Expected set of records were 15

Record count retrieved were only 5

But when we revesed the Left hand side with Right Hand side.

nvl((SELECT max(end_time) from fsi_data_identity fdid WHERE fdid.description = fdi.description),sysdate) =nvl(fdi.end_time, sysdate) 

It gave proper record count has 15.

It is happening at customer place but such issues we could not replicate at our dev setup.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center