Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   reomoving prefixes in primary key values (http://www.go4expert.com/forums/reomoving-prefixes-primary-key-values-t5010/)

kiranbvsn 30Jun2007 15:11

reomoving prefixes in primary key values
 
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


All times are GMT +5.5. The time now is 09:25.