Create PL/SQL function and use it in the etl scenario. Use Oracle global variable
Create PL/SQL function and use it in the etl scenario. Use Oracle global variable
com.toolsverse.etl.driver.oracle.OracleDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
to_value
FUNCTION to_value(v_value in NUMBER) RETURN CHAR IS BEGIN return to_char(v_value); END;
employee
employee_function
true