Try using this:
SUBSTR(<value>, INSTR(<value>,' ') + 1, LENGTH(<value>)) where <value> is
your string.
For example:
SUBSTR('2 Frederic', INSTR('2 Frederic',' ')+1,LENGTH('2 Frederic')) will
return "Frederic"
SUBSTR('99 Jimmy', INSTR('99 Jimmy',' ')+1,LENGTH('99 Jimmy')) will return
"Jimmy"
HTH,
Matt
-----Original Message-----
Sent: Tuesday, November 13, 2001 8:40 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I write in apl/sql code if I want to make an insert from table one
into table two and in one of the fields delete the space in front of the
first blank.
For instance It says
1 John
2 Frederic
99 Jimmy
in table one
and I want the pl/sql code to delete the values in front of the names
wheninserted into table two
so in table two it would be:
just :
John
Frederic
Jimmy
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oldham, Matthew
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
