Which component you will use if you want to send output to Oracle table in Talend Job? only output component required

i amm trying to do some work in sql developer   insert data from nametest to names  i want only to insert year ,name and gender ,then create a id for each data in the databse . what commend shouldi  use ?  i try "INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestest; it shows  Error starting at line : 1 in command -INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestestError at Command Line : 2 Column : 21Error report -SQL Error: ORA-00926: missing VALUES keyword00926. 00000 -  "missing VALUES keyword"*Cause:     how to make it corrrect ?and make a "id "for each data ?

The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.

this oracle code have some error ， how to fix it ? this is the sql code .and it have error . CREATE or replace PROCEDURE CONVERT_VAL(&v1  varchar2(2), &v2 varchar2(2), &amt  number)asval varchar(100);val1 varchar(2):= ':v1';val2 varchar(2):=':v2';amount number:= :amt;BeginSelect case when val1!=val2 then                          case                         when lower(val1)='km' and lower(val2) = 'cm'                                              then amount||lower(val1) ||amount*100000||' '||lower(val2)                                         when lower(val1)='km' and lower(val2) = 'mt'                                                             then amount||lower(val1) ||amount*1000||' '||lower(val2)                                                 when lower(val1)='km' and lower(val2) = 'mm'                                                 then amount||lower(val1) ||amount*1000000||' '||lower(val2)                         when lower(val1)='cm' and lower(val2) = 'km'…