set heading off set feedback off spool d:\text.sql select 'INSERT INTO addrmap(RAW_ADDR,RAW_ADDR_TYPE,MAPPED_ADDR,MAPPED_ADDR_TYPE,STATUS,DESCRIPTION,DISTRICT) values('''||RAW_ADDR||''','''||RAW_ADDR_TYPE||''','''||MAPPED_ADDR||''','''||MAPPED_ADDR_TYPE||''','''||STATUS||''','''||DESCRIPTION||''','''||DISTRICT||''');' from addrmap; spool off
