Using sqlplus COPY command to copy data from one table to another

<?xml version="1.0" encoding="UTF-8"?>
<scenario requiresource="true">
     <name>Using sqlplus COPY command to copy data from one table to another</name>
     <description>Use sqlplus COPY command to copy data from one table to another. Possible in different databases</description>
     <script>oracle_copy</script>
     <driver>com.toolsverse.etl.driver.oracle.OracleDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <variables>
        <NAME label="Property Name:" value = "test" />
     </variables>
     <tasks>
     
          
          <task>
               <name>drop_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   DROP TABLE config_property_stage;
               </sql>
               <onexception action="ignore"/>
          </task>

<task>
               <name>create_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   create TABLE config_property_stage
                   (
                     CONFIG_PROPERTY_NUM	NUMBER(18),
                     NAME	VARCHAR2(255),
                     DESCRIPTION	VARCHAR2(255)
                   );
               </sql>
          </task>

<task>
               <name>copy_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.oracle.OracleCopyTask</class>
               <sql>
                   insert config_property_stage USING
                   select unique CONFIG_PROPERTY_NUM,NAME,DESCRIPTION
                   from config_property
                   where upper(name) like upper('%{NAME}%')
               </sql>
          </task>
     </tasks>
     
     <destinations>
          <destination>
               <name>cfg_props</name>
               <metadata>true</metadata>
               <cursor table="config_property_stage" onfinish="drop" />
          </destination>
     </destinations>
</scenario>