Title: String manipulation
I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3
Here is the code so far:
1 select substr(subject,1,instr(subject,'~')-1) first,
2 substr(subject,instr(subject,'~')+1, instr(subject,'~',1,2)-1) second,
3
Title: RE: OT : Happy Spring Festival
At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl.
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 21, 2004 8:45 AM
To: Multiple recipients of list ORACLE-L
Title: RE: Re[2]: another OCP question -- help me guys
Uh No one can be at Rachel's level. She's the DBA Goddess
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:
Title: Message
Test failed
-Original
Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 1:55 PMTo: Multiple
recipients of list ORACLE-LSubject: testtest