Re: PLsql question

1. create a function CREATE FUNCTION getshortstring( inputstr VARCHAR2 ) RETURN VARCHAR2 AS outstr VARCHAR2(256); -- set the length as your column indx NUMBER; BEGIN -- find the first space in string inputstr. -- If no space character is found - indx is 0 SELECT INSTR( inputstr, ' ',1,1 ) INTO indx FROM DUAL;

outstr := SUBSTR( inputstr, indx+1 );

RETURN outstr;
END; 2. run insert (example)
INSERT INTO new_table (SELECT getshortstring(my_txt_column) FROM old_table);

JP

On Tue 13. November 2001 15:40, you wrote:
> 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: Jan Pruner
  INET: jan_at_pruner.cz

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: ListGuru_at_fatcity.com (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).