# Round functino in oracle

Hello experts,

I have created a table like below:

SQL> create table gunti (col1 number) ;

And inserted one record as below:

SQL> insert into gunti values('-2.1005799412757564E16') ;
SQL> commit;

I want to round the value like -2.10
LVL 17
###### Who is Participating?

Commented:

This one:  -2.1005799412757564E16 equates to -21005799412757564

2.10E16 is scientific notation.  It is a way to show large numbers in a condensed format.  It is not a  number with decimal places.

http://en.wikipedia.org/wiki/Scientific_notation
0

Commented:

select round(col1,2) from gunti;
0

Commented:
I just noticed the scientific notation in the 'string'.  That appears to cause a problem.

Let me see what I can find.
0

Commented:
Now that I've played with this a little, I'm not following the question.

-2.1005799412757564E16 equates to -21005799412757564

How do you expect to get -2.10?
0

Senior Technical Engineer Author Commented:
@slightwv :
0

Senior Technical Engineer Author Commented:
Can you tell me the calculation for conversion based on my input?

How to find the exact conversion numbers for such input like mine.
As far as looked into the logic the notation should be on bases of 10.

0

Commented:
I'm not understanding what you want/need to do with the number.

To display the number in it's complete form in sqlplus just use: set numwidth 20

Below is an example
``````SQL> drop table gunti purge;

Table dropped.

SQL> create table gunti (col1 number) ;

Table created.

SQL> insert into gunti values('-2.1005799412757564E16') ;

1 row created.

SQL> commit;

Commit complete.

SQL> set numwidth 20
SQL> select col1 from gunti;

COL1
--------------------
-21005799412757564

SQL>
``````
0

Senior Technical Engineer Author Commented:
Thanks .. for detail explanation ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.