How to search and replace text in big files

you can also use sed. I used the following command

perl -pi -w -e 's/search/replace/g;' *.sql
-e means execute the following line of code.
-i means edit in-place
-w write warnings
-p loop

for example you can convert oracle dates to mysql in the following way