Search code examples
sqloraclesqldatatypes

Implicit Data Type Conversion in Oracle


Is the statement true?

Comparison between character value and a number value always implicitly converts the character value to the number data type.


Solution

  • Yes it's true.

    The manual pretty much contains the same sentence

    Implicit Data Conversion
    ...
    ...

    • When comparing a character value with a numeric value, Oracle converts the character data to a numeric value.