SQL Language (MOSC)

MOSC Banner

SQL to search for a sub-string of a minimum length of 15 characters in a source string

edited May 6, 2013 5:00AM in SQL Language (MOSC) 9 commentsAnswered ✓
 Hi all,
I have an urgent problem as follows:

I need to search for any word(or more generally the search string which is a 
continuous set of characters/numbers etc. except the space) which has a length of 15 characters or more
in a large string(the source string).

For example:

Consider the string(source string): 'exxxxx R001234juuuAA JH JHGJHG KHKJK65465465 NBVMNBMBEWRE234H.,H '

Here the search string: 'NBVMNBMBEWRE234HH' has a length 19.

So clearly the source string has a search string of length greater than or equal to 15.

Is it can be done in a single SQL which will give the output say 1 for the presence of the search string with required criteria or 0 otherwise?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center