Hi Don/Peasant,

Peasant, I did not have a clue on how to start, had a a mental block so could not do an attempt. I am searching for a script that does atleast some part of it but whenever i change it i get errors and just left me frustrated. Hence i made this post. I will try this and see if it works. thank you for your attempt. I will add a post once i give it a shot.

Don,

Looks like I messed up. Sorry about missing code tags. I will put extra effort to follow the rules. I would recommend if you can put some validation so it does not allow any one posting without code tags. But you will not see that from me every again hopefully. I will put in the explanation with more information.

we have one file that has our sql code that has code numbers to identify if there is an error we can find it with the code number. those code number should should start with

Code:

'0001'

and have code section and then

Code:

 '0002'

and so on, where ever there is a .

Code:

.001

, ""the current number" repeats.

It looks like this. I have changed it start from 1. so Basically I want to update what ever is the number in the

Code:

'0001'

. I have already built up the file by copying pasting code blocks but not updated the numbers 1 by 1. it is a 10000 code blocks file. and it is very laborious to change it one by one to 10000

Code:

l_code_number := (l_src||'0001')::num
(code)
l_code_number := (l_src||'0002')::num
(code)
l_code_number := (l_src||'0002'||'.001')::num
(code)
l_code_number := (l_src||'0003')::num
(code)
l_code_number := (l_src||'0004')::num
(code)
l_code_number := (l_src||'0004'||'.001')::num