Oracle always stores it value according to the declared type, in this example COLUMN is stored as VARCHAR2.

With that declared, Oracle automatically applies datatype conversion, where necessary, and possible. So to process this


So… 27 (INT) is automatically converted to “27” (varchar2), which is then stored in COLUMN.

One must be aware of when type conversions automatically happen in Oracle.