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 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 namestest
Error at Command Line : 2 Column : 21
Error report -
SQL Error: ORA-00926: missing VALUES keyword
00926. 00000 -  "missing VALUES keyword"
*Cause:

how to make it corrrect ?and make a "id "for each data ?

Extracted text: NAMESTEST YEAR_ NAME_ FREQUENCY I GENDERA


Extracted text: NAMES | NAMEID I NAME_ I GENDER I NAMERANK YEAR _