Number Width Issue
Hi,
I have a Table with a column having Number Datatype.
When I do a select on the column I get the result as
1* select api_well_no from borehole where rownum < 10
SQL> /
API_WELL_NO
-----------
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
but if I do set numwidth 15 and reissue the same query I get the results as
API_WELL_NO
---------------
608054000500
608054000501
608054000270
608054000200
608054000700
608054000900
608054000901
608054000902
608054001000
Now my question is that I know I can set this in glogin.sql for sqlplus but i need to send the data to one of the users in an access table. i import the table into access and send the mdb file.
Now the problem is that the data is being imported as
6.0805E+11
6.0805E+11
6.0805E+11
6.0805E+11
and not
608054000500
608054000501
608054000270
608054000200
Is there any way I can fix this.
Thanks
Ronnie
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.