inserting sysdate
Hi -
My local table has a column datatype DATE. I am tyring to insert some records into it fetching data from a remote database. For this date value i am using sysdate. I am not able to insert records into the local table. Do you know what the issue is here?
insert into TABLE A(VAL1, VAL2,VAL3)
select ID,sysdate,description from remote.TAB1@re_link;
Thank you,