Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: find nearest, using index in oracle 8.1.5.0.5
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