Integration

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 multipal values in a table

563050May 19 2007 — edited May 28 2007

Dear Friends
I have table GL_Voucher which coulumn name is voucher_no . this column contain values as bellow.
003 is financial year 2003,
07 is month of July,
00001 is Transaction No. that is generated on next entry on + 1.

0030700001
0030700002
0030700003
0030700004
0030700005

I want to UPDATE that values with only financial year.

003 is financial year 2003, Replace with 007 is financial year 2007,

0070700001
0070700002
0070700003
0070700004
0070700005

I am really disturbed. Please tell me the Query of how I can do in SQL or PLS/SQL or on form basis.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2007

Added on May 19 2007

#application-servers, #oracle-application-server-general

2 comments

680 views