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!

update a date column

530854Sep 28 2006 — edited Sep 28 2006

Hello hello,

I just want to update a column with a specific date.

update table set date = ...

I almost tried everything. Also to_char and to-date and I always get the following error Message:

ORA-01747: invalid user.table.column, table.column, or column specification

The table and column names are correct. It must have something to do with the format of the date or the code itself is principle wrong.

regards phil

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2006

Added on Sep 28 2006

14 comments

545 views