Null (SQL): Difference between revisions

Content deleted Content added
Tag: Reverted
Linxgos (talk | contribs)
Reverting edit(s) by 202.83.17.26 (talk) to rev. 1049280122 by Mindmatrix: Unexplained content removal (RW 16.1)
Line 33:
</syntaxhighlight>
 
This can lead to unanticipated results. For instance, when an attempt is made to divide Null by zero, platforms may return Null instead of throwing an expected "data exception{{snd}} division by zero".<ref name="SQL2003-Part2-Sec626"/> Though this behavior is not defined by the ISO SQL standard many DBMS vendors treat this operation similarly. For instance, the Oracle, PostgreSQL, MySQL Server, and Microsoft SQL Server platforms all return a Null result for the following:
 
<syntaxhighlight lang="sql">