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: [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).
