Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> NUMBER to CHAR conversion
Can anybody help me?
Why the statement:
INSERT INTO sample_table VALUES(TO_CHAR(1,'00'));
returns error:
ERROR at line 1:
ORA-01401: inserted value too large for column
There is 'sample_field' CHAR(2) in 'sample_table'. I thought the statement
have
to write value '01' in the field. But it does not work. Why?
Alec. Received on Thu Apr 06 2000 - 01:21:54 CDT