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!

Varchar to Number conversion

user7351276Jan 20 2011 — edited Jan 20 2011
Hi,
Am trying to convert a varchar to number using to_number

select (substr(value1,69,10)) from test .
this gives 00000000.1


but when I try to convert this to number like
select (to_number(substr(value1,69,10))) from test
then gives "invalid number" error message.

Please let me know if statement is wrong here.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2011
Added on Jan 20 2011
7 comments
10,129 views