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 -> SQL question

SQL question

From: Ed Lufker <elufker_at_swcp.com>
Date: 21 Apr 1998 19:16:42 GMT
Message-ID: <6hiraq$4bm$1@sloth.swcp.com>


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

Original text of this message

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