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!

Get the string until first space

451321Oct 16 2006 — edited Oct 16 2006
hi,
can anyone provide an example how to get the string until the first space?
i mean if the value is :
this is an example

how to get only the word "this" (before the very first space) by select?

thanks in advance,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2006
Added on Oct 16 2006
3 comments
6,180 views