on 2/19/02 5:29 PM, Dave Turner at [EMAIL PROTECTED] wrote:
> Is this a valid hint?
>
> /*+FIRST_ROWS DOMAIN_INDEX_SORT*/
Perhaps. I wasn't sure if the spaces were required or not, but all the
examples in Oracle's docs had them. I will check this out.
>
> If so, your \s+ fails. I don't use Oracle, so I can't check any of this,
> but what about this?
>
> /*+ FIRST_ROWS */ /*+ DOMAIN_INDEX_SORT */
>
> If so, your .* should be .*?
>
.* = match a single character zero or more times, yes?
.*? = the above condition, but only zero or one instances of the above?
What would the .*? do for me?
> Are quoted strings which should not be parsed for */ included? Then
> you'll need to do more complex stuff (see the perl faq).
>
I'm not sure what you mean by this, can you give an example?
> If you use {} instead if // to delimit your RE, you'll be able to
> replace \/ with just /, which makes your code that much more readable.
Simon Cozens also mentioned this.
Peter
--
Peter R. Wood - [EMAIL PROTECTED] - http://prwdot.org/
