Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to do this
sjoshi schreef:
>
> Ok this time I tried using the _ option by specifying 2 character
> before the O and that worked.
>
> 1 Select UTL_RAW.CAST_TO_VARCHAR2(S.OBJECTMONIKER) FROM CORESITE S
> Where
> 2* UTL_RAW.CAST_TO_VARCHAR2(S.OBJECTMONIKER) LIKE '__O%'
> SQL> /
>
> UTL_RAW.CAST_TO_VARCHAR2(S.OBJECTMONIKER)
> --------------------------------------------------------------------------------
> % O L E _ S E R V E R % \ C r o s s S e c t i o n s \ C . s y m
>
> Does that make sense ?
>
Does that perhaps mean the first three characters are not:
percent-space-capitalO?
(You do realize the underscore character is a single
position wildcard?)
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Oct 02 2006 - 13:50:57 CDT