Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Update Numeric Field
I have an Access frontend linked to an Oracle backend. When I run an update
query against a Number field, I have set it equal to "123" instead of 123
(like it's a Character field). Does anyone know why this is? Do I have
something configured incorrectly in my field, or is that just the way Oracle
handles it?
Field Structure
Name: Item Schema: <None> Datatype: NUMBER Size: 38 Scale: 0 Ref: Nulls?: Yes