Home » SQL & PL/SQL » SQL & PL/SQL » How to get a substring from a character on
How to get a substring from a character on [message #682005] Fri, 25 September 2020 03:09 Go to next message
Mark70
Messages: 18
Registered: June 2020
Junior Member
Hi,
I have a table with a column varchar2 where I've got strings of different length and I must extract the substring after the character '-'.
STRING_COL
afg a ga ga ga ggfdg - gfd g f
ok k ok o - gfs gsd gsg sd g sd
okk - jdjdjdj d d
...
I want to get all after the '-' character

Could you tell me how to do it?
Oracle 10g

Thanks in advance!
Mark
Re: How to get a substring from a character on [message #682006 is a reply to message #682005] Fri, 25 September 2020 03:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Could you tell me how to do it?
Yes, I can. The first step is to say "thank you" to the people who helped you in your previous topics.
Re: How to get a substring from a character on [message #682012 is a reply to message #682006] Fri, 25 September 2020 03:45 Go to previous messageGo to next message
Mark70
Messages: 18
Registered: June 2020
Junior Member
ok I've thanked
Re: How to get a substring from a character on [message #682013 is a reply to message #682012] Fri, 25 September 2020 03:47 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Come on, man. I do not see any solutions posted, nothing that would help anyone else learn.

leech

Re: How to get a substring from a character on [message #682014 is a reply to message #682005] Fri, 25 September 2020 10:44 Go to previous message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
INSTR + SUBSTR.

SY.
Previous Topic: Can't connect with new user created
Next Topic: find the next occurrence of an event based on another event
Goto Forum:
  


Current Time: Thu Mar 28 04:47:16 CDT 2024