UNIX for Advanced & Expert Users

I m trying to grep 'select * from' from a script, but the problem is with the * ...
I think its taking * as some special character ...

when I try to do grep '*' test (test is my test file) its displaying *

But when I am trying to do grep 'select * from' test its not showing anything ...

I tried different probabilities but not able to figure out the solution ...

Any help would be greatly appreciated

Thanks
RDR

Code:

grep 'select \* from'

Thank You So much ...It works fine ....

Sometimes you miss on small things ...
I was trying to do grep 'select .\* from' ....

Can you help me with this also .... I was actually trying to find few strings (which are in a table) in a bunch of scripts .... I m trying to do this ... can you tell me if I am doing this right ???

Code:

sqlplus un/pwd@db
spool dquery1.log
typeset n
select distinct column_name into n from table_name;
select count(1) into m from table_name;
for i in {1..m}
do
  grep -i 'select \* from /^n/' * 
done
exit
ENDOFSQL
spool off