SQLPlus Modify Type Support
| Source Type | Convert to this type | Support status | Conversion conditions |
| Short | Int | √ | Unlimited |
| Long | √ | Unlimited | |
| Double precision | √ | Unlimited | |
| Single precision | √ | Unlimited | |
| Text type | √ | Unlimited | |
| Wide character | √ | Unlimited | |
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | A value other than 0 is true, a value of 0 is False, and a null value is null | |
| Date | √ | From 1900/1/1, the value is converted in days. If the value is 36, the conversion result is: 1900/2/6 | |
| Byte type | √ | Conversion is supported only when the value is in the range 0, 255; Failed to convert. | |
| Long Binary | x | ||
| Int | Short | √ | The byte length of the field value exceeds 2 (that is, the value size is greater than 32767). Failed to convert. |
| Long | √ | Unlimited | |
| Double precision | √ | ||
| Single precision | √ | ||
| Text type | √ | ||
| Wide character | √ | ||
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | A value other than 0 is true, a value of 0 is False, and a null value is null | |
| Date | √ | From 1900/1/1, the value is converted in days. If the value is 36, the conversion result is: 1900/2/6 | |
| Byte type | √ | Conversion is supported only when the value is in the range 0, 255; Failed to convert. | |
| Long Binary | x | ||
| Long | Short | √ | When the value size is not in -32768, 32767, Failed to convert. |
| Int | √ | Failed to convert. When the value size is not between -2147483648, 2147483647. | |
| Double precision | √ | ||
| Single precision | √ | ||
| Text type | √ | ||
| Wide character | √ | ||
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | A value other than 0 is true, a value of 0 is False, and a null value is null | |
| Date | √ | From 1900/1/1, the value is converted in days. If the value is 36, the conversion result is: 1900/2/6 | |
| Byte type | √ | Conversion is supported only when the value is in the range 0, 255; Failed to convert. | |
| Long Binary | x | ||
| Double precision | Short | √ | Keep only the integer part of the numeric value after conversion. When the size of the numeric value is not between -32768, 32767, Failed to convert. |
| Int | √ | Keep only the integer part of the numeric value after conversion. When the size of the numeric value is not between -2147483648, 2147483647, Failed to convert. | |
| Long | √ | After conversion, only the integer part of the value is retained, and the value size is not in the -9223372036854775808, 9223372036854775807, the Failed to convert. | |
| Single precision | √ | Failed to convert. When the value is outside the single-precision range. | |
| Text type | √ | Unlimited | |
| Wide character | √ | Unlimited | |
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | A value other than 0 is true, a value of 0 is False, and a null value is null | |
| Date | √ | From 1900/1/1, the value is converted in days. If the value is 36, the conversion result is: 1900/2/6 | |
| Byte type | √ | Keep the integer value after conversion. Only when the value is within the range of 0, 255, conversion is supported. If the value exceeds the range, Failed to convert. | |
| Long Binary | x | ||
| Single precision | Short | √ | Keep only the integer part of the numeric value after conversion. When the size of the numeric value is not between -32768, 32767, Failed to convert. |
| Int | √ | Keep only the integer part of the numeric value after conversion. When the size of the numeric value is not between -8388608, 8388607, Failed to convert. | |
| Long | √ | After conversion, only the integer part of the value is retained, and the value size is not in the -9223372036854775808, 9223372036854775807, the Failed to convert. | |
| Double precision | √ | Failed to convert. When the value is outside the single-precision range. | |
| Text type | √ | Unlimited | |
| Wide character | √ | Unlimited | |
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | A value other than 0 is true, a value of 0 is False, and a null value is null | |
| Date | √ | From 1900/1/1, the value is converted in days. If the value is 36, the conversion result is: 1900/2/6 | |
| Byte type | √ | Keep the integer value after conversion. Only when the value is within the range of 0, 255, conversion is supported. If the value exceeds the range, Failed to convert. | |
| Long Binary | x | ||
| Text type | Short | √ | If the field value is an integer and the number is between -32768, 32767, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. |
| Int | √ | If the field value is an integer and the numeric value is between -2147483648, 2147483647, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. | |
| Long | √ | The field value is an integer, and the value is in the -9223372036854775808, 9223372036854775807, the conversion is successful, and if there is a non-numeric string or decimal, the Failed to convert. | |
| Double precision | √ | If the field value is a numeric value and is within the range of the double-precision value domain, the conversion can be successful. If there is a non-numeric string, Failed to convert. | |
| Single precision | √ | If the field value is a numeric value and is within the single-precision value domain, the conversion can be successful. If there is a non-numeric string, Failed to convert. | |
| Wide character | √ | ||
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | When the field values are all non-negative integers, the modification can be successful. Non-0 characters are converted to True, and 0 is converted to False. If there is a non-numeric string, Failed to modify | |
| Date | √ | When the field value format is YY/mm/DD or YY/mm/DD When HH: mm: SS, it can be modified successfully, and the date form can also be used-or space as a separator, for example: 2020/11/20 14:16:05, 2020-11-20 14:16:05, 2020 11 20 14:16:05 | |
| Byte type | √ | Keep the integer value after conversion. Only when the value is within the range of 0, 255, conversion is supported. If the value exceeds the range, Failed to convert. | |
| Long Binary | x | ||
| Wide character | Short | √ | If the field value is an integer and the number is between -32768, 32767, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. |
| Int | √ | If the field value is an integer and the numeric value is between -2147483648, 2147483647, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. | |
| Long | √ | If the field value is an integer and the number is between -9223372036854775808, 9223372036854775807, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. | |
| Double precision | √ | If the field value is a numeric value and is within the range of the double-precision value domain, the conversion can be successful. If there is a non-numeric string, Failed to convert. | |
| Single precision | √ | If the field value is a numeric value and is within the single-precision value domain, the conversion can be successful. If there is a non-numeric string, Failed to convert. | |
| Text type | √ | ||
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | When the field values are all non-negative integers, the modification can be successful. Non-0 characters are converted to True, and 0 is converted to False. If there is a non-numeric string, Failed to modify | |
| Date | √ | When the field value format is YY/mm/DD or YY/mm/DD When HH: mm: SS, it can be modified successfully, and the date form can also be used-or space as a separator, for example: 2020/11/20 14:16:05, 2020-11-20 14:16:05, 2020 11 20 14:16:05 | |
| Byte type | √ | Keep the integer value after conversion. Only when the value is within the range of 0, 255, conversion is supported. If the value exceeds the range, Failed to convert. | |
| Long Binary | x | ||
| Character type | Short | √ | If the field value is an integer and the number is between -32768, 32767, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. |
| Int | √ | If the field value is an integer and the numeric value is between -2147483648, 2147483647, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. | |
| Long | √ | If the field value is an integer and the number is between -9223372036854775808, 9223372036854775807, the conversion is successful. If there is a non-numeric string or decimal, the conversion is Failed to convert. | |
| Double precision | √ | If the field value is a numeric value and is within the range of the double-precision value domain, the conversion can be successful. If there is a non-numeric string, Failed to convert. | |
| Single precision | √ | If the field value is a numeric value and is within the single-precision value domain, the conversion can be successful. If there is a non-numeric string, Failed to convert. | |
| Text type | √ | ||
| Wide character | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | When the field values are all non-negative integers, the modification can be successful. Non-0 characters are converted to True, and 0 is converted to False. If there is a non-numeric string, Failed to modify | |
| Date | √ | When the field value format is YY/mm/DD or YY/mm/DD When HH: mm: SS, it can be modified successfully, and the date form can also be used-or space as a separator, for example: 2020/11/20 14:16:05, 2020-11-20 14:16:05, 2020 11 20 14:16:05 | |
| Byte type | √ | Keep the integer value after conversion. Only when the value is within the range of 0, 255, conversion is supported. If the value exceeds the range, Failed to convert. | |
| Long Binary | x | ||
| Boolean | Short | √ | True to 1, False to 0 |
| Int | √ | True to 1, False to 0 | |
| Long | √ | True to 1, False to 0 | |
| Double precision | √ | True to 1, False to 0 | |
| Single precision | √ | True to 1, False to 0 | |
| Text type | √ | True to 1, False to 0 | |
| Wide character | √ | True to 1, False to 0 | |
| Character type | √ | True to 1, False to 0 | |
| Date | √ | True to 1900/1/2, False to 1900/1/1 | |
| Byte type | √ | True to 1, False to 0 | |
| Long Binary | x | ||
| Date | Short | x | |
| Int | x | ||
| Long | x | ||
| Double precision | x | ||
| Single precision | x | ||
| Text type | √ | After modifying to text type, the date sequence and Display Method will change, such as 2020/11/19 14:30:10 Converted to 11 19 2020 2: 30PM | |
| Wide character | √ | After modifying to text type, the date sequence and Display Method will change, such as 2020/11/19 14:30:10 Converted to 11 19 2020 2: 30PM | |
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | x | ||
| Byte type | x | ||
| Long Binary | x | ||
| Byte type | Short | √ | Unlimited |
| Int | √ | Unlimited | |
| Long | √ | Unlimited | |
| Double precision | √ | Unlimited | |
| Single precision | √ | Unlimited | |
| Text type | √ | Unlimited | |
| Wide character | √ | Unlimited | |
| Character type | √ | When the number of characters is less than or equal to the character length, the conversion is successful; when the number of digits is greater than character length, the conversion is Failed to convert. | |
| Boolean | √ | A value other than 0 is true, a value of 0 is False, and a null value is null | |
| Date | √ | From 1900/1/1, the value is converted in days. If the value is 36, the conversion result is: 1900/2/6 | |
| Long Binary | x | ||
| Long Binary | Short | x | |
| Int | x | ||
| Long | x | ||
| Double precision | x | ||
| Single precision | x | ||
| Text type | x | ||
| Wide character | x | ||
| Character type | x | ||
| Boolean | x | ||
| Date | x | ||
| Byte type | x |
Related content
Modification of PostGreSQL Type