replacing text within an oracle sql file

[froghead]

I have a set of oracle sql files, each with an insert and delete statement as follows:

delete from t_schema_version where version = '1.41'
/
insert into t_schema_version (version, RELEASE_DATE, BUILD_DATE,COMMENTS,APPLIED_BY)
values ('1.41', sysdate, sysdate, 'Patch 41', 'pk')
/
commit
/

I wish to replace each occurence of 41 with whatever number I supply as a parameter. The questions I have are:
1. Is this possible from the command line?
2. Can I do this with awk or can I use "vi"?

thanks in advance

 

[Annihilannic]

1. Yes

2. sed is the most appropriate tool for this.

sed 's/41/42/g' originalfile > newfile for example.

Annihilannic.