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: find nearest, using index in oracle 8.1.5.0.5

Re: find nearest, using index in oracle 8.1.5.0.5

From: Evgeny Sorokin <sor1_at_aha.ru>
Date: Tue, 22 Feb 2000 12:53:07 +0300
Message-ID: <88tlqg$24lr$1@gavrilo.mtu.ru>


I don't know fixed i_a
:a is parameter.

I already received solution from russian oracle news board: SELECT /*+ INDEX_ASC (index_name ) */ f1 FROM t1 WHERE f1 >:a AND ROWNUM = 1;
and
SELECT /*+ INDEX_DESC ( index_name ) */ f1 FROM t1 WHERE f1 <:a AND ROWNUM = 1;
Author - Maxim Stiazhkin.
Thank you for attention Received on Tue Feb 22 2000 - 03:53:07 CST

Original text of this message

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