how deal with minus operation does not work while existing order by cause!
734346Nov 13 2009 — edited Nov 14 2009Hi everybody:
i have some requirement to compare two pl/sql statement limit to use select statement
i finally find that when the one of statement beside minues operator has exists * order by *
cause ,oracle will complain error in statement !!!
my requirement is only to compare to if the two statement results equals , can anybody help to this !!
thanks !!!!
Edited by: user11064241 on 2009-11-13 上午6:46