UNIX for Dummies Questions & Answers

Afternoon,

I have a problem with the FIND and GREP commands working together.

The command that I am typing is this:-

find . -name *.sql -print --- This finds all files with an SQL suffix

I then want to examine all those files to check for the existence of a string in them.

I am attempting to find "ORACLE" in the matching files by typing this:-

find . -name *.sql -print -exec grep "ORACLE" *

This is obviously not correct. What should it be?

Cheers

Jason

find . -name "*.sql" -exec grep -l "ORACLE" {} \;

This will list all the files which have the term "ORACLE" in them.

Regards.

Thanks very much for your speedy response.

Magnificent.