Hi DBA's

I have question which may be simple for you:

why i am getting error [1]: (Error): ORA-01722: invalid number when i am executing: select * [table_name] where username = 4064319769
and to fix this problem i have to add sinle quotes for 4064319769 value.
and i am not getting this error when executing absolutely the same select against another database which has the same tables structure?

Which setting is different between this databases?


M.


Oracle LazyDBA home page