OraFAQ Forum: SQL & PL/SQL » How to get a substring from a character on

Home » SQL & PL/SQL » SQL & PL/SQL » How to get a substring from a character on

Fri, 25 September 2020 03:09

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

Fri, 25 September 2020 03:37

John Watson
Messages: 8979
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.

Fri, 25 September 2020 03:45

Mark70
Messages: 18
Registered: June 2020

Junior Member

ok I've thanked

Fri, 25 September 2020 03:47

John Watson
Messages: 8979
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

Fri, 25 September 2020 10:44

Solomon Yakobson
Messages: 3305
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 Jul 24 20:57:43 CDT 2025