Re: Where can I get a complete list of all SQL Hints?

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:k89oevc3he6pc5tvpi93u65ht29fk44egp_at_4ax.com...
> On Sat, 14 Jun 2003 13:16:17 +0100, "Niall Litchfield"
> <niall.litchfield_at_dial.pipex.com> wrote:
>
> >"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
> >news:e7slevc2j00mvqgr0qjc9havkbp53lo5qg_at_4ax.com...
> >> On Sat, 14 Jun 2003 03:59:26 +0000, Franklin
> >> <member29243_at_dbforums.com> wrote:
> >>
> >> >
> >> >You can use grap and strings to get them directly from the Orale
> >> >executable:
> >> >
> >> >strings $ORACLE_HOME/bin/oracle> hints.lst
> >> >
> >>
> >> You mean you can read the file oracle.exe file for the hints?
> >
> >Thats exactly what he means. strings pulls out all readable strings from
a
> >binary file on unix. There is also a version for windows.
>
> where can I findthe Windows version?

I knew you'd ask that :( I can't now find the unix utils for windows that I downloaded at work, but there is a strings utility at the sysinternals site. I guess that strings is also included in cygwin.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************