In Oracle view to add the order by the wrong results is what circumstance-CodePudding

Issue the following
When I use the SQL query is normal

But when I put the SQL query in the view in this situation, it is strange that is according to the FILE_STATUS FILE_STATUS_NAME, but it has no problem, which the eldest brother may explain why this is, please

CodePudding user response:

Figure is not clear,

CodePudding user response:

reference 1/f, faint blue water fountain response:

figure is not clear,

Click + to see on the picture it

CodePudding user response:

Strange, the same is not the same as the field result zha

CodePudding user response:

The

reference 3 floor baidu_36457652 response:

a bit odd, the same is not the same as the field result zha?

Yes, more strange is my view of the order by the words of removing is normal

CodePudding user response:

Sort field is OPERTION_DATE, so the system give the result is no problem, if there is the same value, then every time the query results will be not stable, suggest to add the other fields, to ensure that the order of the results;

PS: the order of the query, now is the same every time, when the business data after a large number of written or delete, this order will surely change;

CodePudding user response:

To ask! ~ ~ ~ ~ ~

CodePudding user response:

Agree with the fifth floor, you sort field is the date

CodePudding user response:

reference 5 floor wmxcn2000 reply:

sort field is OPERTION_DATE, so the system give the result is no problem, if there is the same value, then every time the query results will be not stable, suggest to add the other fields, to ensure that the order of the results;

PS: the order of the query, now is the same every time, when the business data after a large number of written or delete, this order will surely change;

Thank you, I have not considered this problem

But my main problem here is the second picture FILE_STATUS_NAME is obviously through FILE_STATUS this field with DECODE () function, why FILE_STATUS this field value is 0, and the original data in the table is different, but get FILE_STATUS_NAME is correct
Very don't understand the situation, the great god solution under confused