I have data in a table with primary key value .
The primary key value has prefix with zero's.
Example:1
0000000001
0000000002
0000000003
...
.....
0000000010
0000000011
....
...
....
0000000099
0000000100
----
---
0000000999
0000001000
0000001001
My requirment is to manuall modify the data by SQL Queries in all tables
is to remove the prefix ZERO's.
At present When inserting a new record for this primary key they are
retriving the last value removing the prifx zeros and adding a value to
that and inserting a new record with prefix's again manually
For new record i will try to modify in java but for existing records in
PRDOUCTION DATA Could you please suggest me to remove the prefix as..
Example:1
1
2
3
...
.....
10
11
....
...
....
99
100
----
---
999
1000
1001