This content has been marked as final. Show 5 replies
Please help this issue.
SQL> create table t51(t5 NUMBER(25,8));
SQL> insert into t51 values (100000000000000000.00000);
insert into t51 values
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
Connected to: Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> create table t51(t5 NUMBER(25,8)); Table created. SQL> insert into t51 values (100000000000000000.00000); insert into t51 values (100000000000000000.00000) * ERROR at line 1: ORA-01438: value larger than specified precision allowed for this column SQL> ed Wrote file afiedt.buf 1* insert into t51 values (10000000000000000.00000) SQL> / 1 row created. SQL> -- one digit too large SQL>
Status Level: Newbie
Registered: Oct 12, 2009
Total Posts: 10
Total Questions: 7 (7 unresolved)
why do you waste time here when you NEVER get your questions answered?
Murali.Raju wrote:either change the data or change the table; Oracle is to dumb to mis-report reality
I need same value to insert.
we have already same value in other table.
insert into rmurali.t51 select * from xxx;
1 row created.
but i have insert command show error.
You don't have t convince me of anything.
You need to have Oracle perform without throwing any error
Paste result of following query from both of the database. Paste your result in CODE tag please.
select property_name,property_value from database_properties where property_name='NLS_LENGTH_SEMANTICS' or property_name='NLS_CHARACTERSET';