| Exponent [message #372161] |
Wed, 17 January 2001 08:09  |
Eileen
Messages: 2
Registered: January 2001
|
Junior Member |
|
|
I altered the table to change the length of a number column from 7 to 10. Then inserted the area code to the number. For e.q. 7034561234. I use SQL*Plus tool to display my data. (select phone_number from security) Instead of it displaying as 7034561234, it comes up as 7.143+. If I insert the data as 4561234, it will display as 4561234. Is there a parameter of some sort to fix it? There's no scale or decimal.
The oracle database is running off of Windows NT.
I have a similar set up on the Unix side and everything is fine. I exported the table from Unix platform to Windows NT platform.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
