hi,
when i try insert into table Area this values 5.4 I get always this error:
ORA-01861 literal does not match format string
datatype columns are number(10,2)
Could you help me??
Thanks
Raf
Printable View
hi,
when i try insert into table Area this values 5.4 I get always this error:
ORA-01861 literal does not match format string
datatype columns are number(10,2)
Could you help me??
Thanks
Raf
Can't be.. Post complete sql statement and table description..
Code:SQL> create table tab1 (id number(10,2));
Table created.
SQL> desc tab1
Name Null? Type
----------------------------------------- -------- ------------------
ID NUMBER(10,2)
SQL> insert into tab1 values (5.4);
SQL> insert into tab1 values (1234567.12);
SQL> insert into tab1 values (12345678.12);
1 row created.
SQL> select * from tab1;
ID
----------
5,4
1234567,12
12345678,1