Re: PL/SQL cursor status without fetching???

Correct me if I'm wrong. Isn't the Function based index a feature of EE. That also begs another question, can you afford it?

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:albho502e0m_at_drn.newsguy.com...
> In article <3D7947F1.F254D04D_at_oracle.com>, Martin says...
> >
> >This is a multi-part message in MIME format.
> >--------------139C138F58951CA6FE7B6C06
> >Content-Type: text/plain; charset=UTF-8
> >Content-Transfer-Encoding: 7bit
> >
> >Thomas Kyte wrote:
> >
> >> In article <alagg9$1oqfm3$1_at_ID-114658.news.dfncis.de>, "Giovanni
 says...
> >> [snip]
> >>I sure hope you know ALL ABOUT function based indexes, or we have
 another java
> >>program going down the tubes real fast (user VARCHAR2, skip the trim,
 whats up
> >> with upper(zip_code)?).....
> >> [snip]
> >
> >Upper(zip_code) would only make sense if there may be addresses outside
 USA e.g.
> >Canada, UK which have alphanumeric post codes. Which makes me wonder why
 the
> >WHERE
> >clause makes no reference to country code
>
> You know, I'm always forgetting about those other places... (only
 kidding)..
>
> btw, if they do this upper(trim()) thing, read about FUNCTION BASED
 INDEXES
> (please)
>
>
>
> >
> >--------------139C138F58951CA6FE7B6C06
> >Content-Type: text/x-vcard; charset=UTF-8;
> > name="martin.doherty.vcf"
> >Content-Transfer-Encoding: 7bit
> >Content-Description: Card for Martin Doherty
> >Content-Disposition: attachment;
> > filename="martin.doherty.vcf"
> >
> >begin:vcard
> >n:Doherty;Martin
> >tel;work:+1 650 506-8398
> >x-mozilla-html:FALSE
> >url:http://industries.oraclecorp.com
> >org:Oracle Corporation;Industry Solutions
> >version:2.1
> >email;internet:martin.doherty_at_oracle.com
> >title:Senior Software Specialist
> >adr;quoted-printable:;;Mail Stop C3038=0D=0A10 Twin Dolphin
 Dr=0D=0A;Redwood
> >Shores;CA;94065;USA
> >fn:Martin Doherty
> >end:vcard
> >
> >--------------139C138F58951CA6FE7B6C06--
> >
>
> --
> Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Sat Sep 07 2002 - 00:41:22 CDT