OraFAQ Forum: SQL & PL/SQL » String Manipulations

Home » SQL & PL/SQL » SQL & PL/SQL » String Manipulations (Oracle 11g R2)

Mon, 04 July 2016 12:59

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Gurus,

I am trying to get this problem done.
I have a string which looks like this

a#,b,cd#,e,f

Now by doing a split string or any other way i have to identify the

b,c,e,f

in one set and

a,d

in another because that has #

Javed

Mon, 04 July 2016 13:36

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Explain the rules with words.

Previous Topic:	Pick One : A Query for Multiple Submission of form but to take only first one.
Next Topic:	SQL problem - variation on top-n-of-group. DDL and DML supplied.

Goto Forum:

]

Current Time: Sat Jun 06 09:41:17 CDT 2026