921784 wrote:Sorry, it's unclear what you want.
Can any one help me to select varchar2 without approximation .
Date+When SQL*Plus doesn't have room to display a large number, such as 208099876543210, exacly, then it uses scientific notation, as shown above. The number stored in the table is not rounded or approximated.
*16/04/2012 ;208; 10; *2.0810E14**+ this one should not be approximatif
To change the default amount of space for all NUMBER columns, you can use the SQL*Plus SET NUMWIDTH command:
COLUMN col_4 FORMAT 999999999999999
Also, instead of displaying a NUMBER, you can use TO_CHAR to explicitly convert it to a VARCHAR2, in whatever format you want:
SET NUMWIDTH 15
SELECT ... , TO_CHAR ( col_4 , '999999999999999' ) AS f_col_4 ...