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!

using instr and substr

2795332Feb 23 2016 — edited Feb 23 2016

Hi,

I m having Varchar2 column in a table having below values.

7060761-937607

9061-937610

20627663535-938607

How can i get just the the first part. Also i need it in NUMBER datatype

7060761

9061

20627663535

Thanks

This post has been answered by Paulzip on Feb 23 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2016

Added on Feb 23 2016

5 comments

2,061 views