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
