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!

Problem with Data conversion in SQL

User_9XA6OApr 3 2017 — edited Apr 4 2017

HI,

I have table Org, contains column unit_inc.

Unit_inc has NUMBER datatype  contains data in number format like :

unit_inc

1

2

3

1

10.

I have to convert this data into decimal , so final output would be like this:

1.0

2.0

3.0

1.0

10.0

I tried with to_char function I got the solution but I m not able to insert the same value into column who has NUMBER datatype. if , I converted it into NUMBER format then decimal value not comes.

So could help me to overcome this issue and send decimal value e.g.: 1.0 .  2.0 etc. into final target.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2017
Added on Apr 3 2017
#oracle, #sql, #sql-pl-sql
14 comments
1,470 views