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!

substr on address

598866Sep 11 2008 — edited Sep 12 2008
i have this data:

1111 ABC Ave Unit 123
1111 ABC Ave Box No. 444

How do I get numbers after Unit or Box #, however when I do Substr, it would not give me the right number because the position is not consistent.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2008
Added on Sep 11 2008
11 comments
290 views