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!

Extract string between two parts

869328Dec 6 2011 — edited Dec 6 2011
Hi all,

I am trying to extract a string using the regexp substr with no luck:

string is :

ws-servername.domain name

example:

ws-db1.mydomain

desired outcome :

servername only

any ideas ?

Thanks

Yoav
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2012
Added on Dec 6 2011
5 comments
16,118 views