Videos

Published on January 27th, 2019 📆 | 6927 Views ⚑

0

[en] ORACLE 12.2 TOP New Features: a FUNCTION for checking DATATYPE. Good bye ORA-01861, ORA-01722

https://www.ispeech.org

ORA 01861: literal does not match format string.
ORA 01722: invalid number.

Following is the list of supported datatype:

1. NUMBER
2. DATE
3. TIMESTAMP
4. TIMESTAMP WITH TIME ZONE
5. BINARY_FLOAT
6. BINARY_DOUBLE
7. INTERVAL DAY TO SECOND
8. INTERVAL YEAR TO MONTH

Tiếng Việt: https://youtu.be/w6gXv8-yYI4

source

Tagged with: 01722 • 01861 • bye • checking • Database (Software Genre) • datatype • exploit-db • features • function • Good • invalid number • literal does not match format string • ORA 01722 • ORA 01861 • ORA01722 • ORA01861 • oracle • Oracle Database (Software) • Oracle database 12.2 • oravn.com • Software (Industry) • SQL Developer • TOP • TOP new feature for developers • Tutorial (Media Genre) • validate conversion • validate datatype • validate date • validate number