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 script to change the month alone

Balaji MadhavanJul 29 2019 — edited Jul 29 2019

Dear All,

Please help me in developing a SQL script to change the month JUL as JUN My records are as follows.

ID Date

897 10-JUL-17 06.39.55.000000000 PM

898 10-JUL-17 06.39.55.000000000 PM

899 10-JUL-17 06.40.14.000000000 PM

900 10-JUL-17 06.41.34.000000000 PM

1780 16-JUL-17 04.38.02.000000000 PM

Regards,

Balaji

Added on Jul 29 2019

#script

3 comments

2,459 views