Do you have a favourite (or favorite) joke in the
Oracle manuals. I've been reading the Oracle 9
SQL reference manual - as one does from time
to time - and spotted this gem on p. 2-97:
quote
/*+ ordered_predicates */
Use this hint in the WHERE clause of SELECT
statements.
/quote
Can I
You mean all this time my hints like the following:
select *
from table
where /*+ LET_ME_CHOOSE_THE_ORDER */
/*+ DO_ME_FIRST */ col1 = 12 and
/*+ NOT_ME_YET */ col2 = 13 and
/*+ WHEN_YOU_GET_A_MOMENT_TRY_ME */ col3 = 14
isn't going to work ?
:-)
--- Jonathan Lewis [EMAIL PROTECTED]
:
co.uk Subject: Re: OT: Funniest line in the
manual.
Sent