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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

update with to_char function

423371Mar 4 2005 — edited Mar 4 2005

Guys

I have this update DML statement

update testdate
set to_char(deeddate, 'mm/dd') = to_char(birthdate, 'mm/dd')
where did = 1

What I am trying to do is replace only the 'mm/dd' part of the birthdate with deeddate's 'mm/dd', while I dont want to change '/yyyy hh:mm:ss' part of birthdate.

But I get an error as ORA-00927

Please suggest me if you any better way of writing the DML statement.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2005

Added on Mar 4 2005

1 comment

315 views