I have 2 tables in oracle database.
First table is Names and it has Columns A,B,C
Second table is NamesHistory which has columns AH,BH,CH,HistoyDate
I want to move record from table names to NamesHistory.Data from column A will go in column AH,from B to BH so on.
I want to use column HistoyDate, to trace at which date this record was moved to history table.
initially when HistoyDatecolumn was not added i used query
INSERT INTO NamesHistory (AH,BH,CH) SELECT A,B,C FROM Names;
Now in column NamesHistory i want to insert SYSDATE.
Can someone tell me how to do so?