Replace text in multiple files

A simple perl command to replace all occurencies of 'RESULT_FAILURE' with 'RESULT_FAIL' in all *.sql files in current directory:

perl -pi -e 's/RESULT_FAILURE/RESULT_FAIL/g' *.sql