Oracle Cast Function: ORA-01438: value larger than specified precision allowed for this column

Error Description:
Oracle SQL query with cast function failed with following error message.
SQL> select cast(deptno as numeric(1)) from dept;
select cast(deptno as numeric(1)) from dept
            *
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column

 

dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google