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!

extract text after a ',' comma

643395Jun 23 2008 — edited Jun 23 2008

how do i extract text after a ',' comma for example i have address in this format:

ZION , IL 60099
and i want to extract the state and zipcode after ',' only

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2008

Added on Jun 23 2008

5 comments

3,668 views