Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL question
Hi All:
Is this allowed
select /*+ INDEX(tab1 index1) INDEX(tab2 index2) */
MAX(NVL(loc,'0')) from tab1, tab2 where tab1.field = tab2.field and tab1.field = tab2.field;
Will this work????
thanks
eddie lufker
Received on Tue Apr 21 1998 - 14:16:42 CDT