| format problem [message #73012] |
Wed, 14 January 2004 05:28  |
James
Messages: 120
Registered: June 2000
|
Senior Member |
|
|
I have to load txt file in oracle table.
In field phone_number i have 8.61065E+11.
How can I load this field in format 861065000000?
Thanks.
|
|
|
|
| Re: format problem [message #73017 is a reply to message #73012] |
Thu, 15 January 2004 01:51  |
 |
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
If phone_number is a numeric field, then that is a valid number in scientific notation. You just need to change how you display it. You could, for example, increase the numwidth, as demonstrated below.
scott@ORA92> select * from oracle_table;
PHONE_NUMBER
------------
8.6107E+11
scott@ORA92> set numwidth 30
scott@ORA92> select * from oracle_table;
PHONE_NUMBER
------------------------------
861065000000
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
