insert into TABLE by SELECT ...

 

insert into isp_rmi3 (
      
      select r.id,
             r.blue_id,
             r.sell_channel,NULL,
             r.interface_id,
             NULL,
             NULL,
             r.url,
             r.request_xml_template_file,
             r.httpclient_service,
             r.status,
             r.http_client_params_id,
             r.request_xml_template,
             SYSDATE
        FROM ISP_RMI R
        WHERE R.SELL_CHANNEL = 1

)