Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where can I get a complete list of all SQL Hints?

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

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 14 Jun 2003 13:16:17 +0100
Message-ID: <3eeb11e1$0$961$cc9e4d1f@news.dial.pipex.com>


"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.

-- 
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
******************************************
Received on Sat Jun 14 2003 - 07:16:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US