Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i display the Number instead of E

972355May 31 2013 — edited Jun 3 2013

Hello Everyone ;

I am getting confused. How can i display the Number but the Exponential value is coming as E.

SQL> select sum(amount_sold) from sales;

SUM(AMOUNT_SOLD)
1.1287E+11

Table details ..

SQL> desc sales

Name Null? Type

AMOUNT_SOLD NUMBER

i want to change 1.1287E+11 to "numeric"

DB : 10.2.0.4
os : rhel 5.1

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2013

Added on May 31 2013

#general-database-discussions

7 comments

9,855 views