Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting sysdate

user626688Dec 20 2011 — edited Dec 20 2011
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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2012
Added on Dec 20 2011
9 comments
254 views