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 (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

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