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 the string to integer

610101Jun 2 2008 — edited Jun 2 2008

I had the string "FAQUAL000K050" -as item_code . I want to display the last 3 digits in packing column heading, and convert the result as integer /number

The substr(item_code,11,4) is statement the result of which i want to convert to number /inreger.

Kindly guide me on this..

Yogesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2008

Added on Jun 2 2008

3 comments

1,804 views