PL/SQL (MOSC)

MOSC Banner

String Comparison

edited Dec 16, 2013 9:58AM in PL/SQL (MOSC) 4 commentsAnswered ✓

Hi,

Let's say we have two strings, as follows:

STRING_A    VARCHAR2(100) := '60';

STRING_B    VARCHAR2(100) := '006,6,060,600,60,666,0060';

I would like to compare STRING_A to STRING_B to find only the value '60'.   

Can you recommend a way to do this?

Thank you for your help.

p.s.  We use Oracle 11G.

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