Skip to Main Content
Forums

SQL & PL/SQL

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 to convert exponent to number format

user9293401Dec 16 2013 — edited Dec 16 2013

Hi,

how to convert exponent to number format.My column is in number and the data is in exponent format .for example  data is 2.44705130197009E18 .when i do field name haveing this data like

select * from table name where filed name =2.44705130197009E18 ,field name  is of number (20) data type .but i am not getting any data fectched .

your advice is at most appriciated .

Regards,

Suja
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2014
Added on Dec 16 2013
11 comments
49,472 views