SQL Language (MOSC)

MOSC Banner

Any Function or Combination of Functions to Find Occurrence from End of String and Extract the Data

edited Apr 11, 2012 4:41AM in SQL Language (MOSC) 8 commentsAnswered ✓

 Hi Folks

looking to find a way to find an occurrence of a character starting at the end of the string
is there any function or combination of functions that will give me that location

would like to extract out everything after the period
line may have more than one period and that is why i need to start from the end

example string(s)


this is my document.txt

this is document 2.0.txt

Thanks
Jim



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