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

Labels

Oracle (577) General (60) Unix (47) Script (40) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer