Something like ... insert into table1 (col1) select replace(substr(col_1,1,2) || '-' || substr(col_1,3),'A','B') from table2 / ?? Raj --- Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote: > Hello guys, > > I could use a few tips here. > > I have a sql statement: > > insert into table1 > ( > col1 > ) > select col1 from tabl2; > > Problem is, I need to modify the data in the column from table2 first before > inserting to > table1. Like add a dash, after the third character ... chnage all A's to B's > sort of thing. > > Can you guys give me a few hints and perhaps a few keywords I can use to > search google for? > > Thank you very much. > > -- > Lyndon Tiu > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------