Query strange behaviour...please help...
Dear All,
I do have one query having two where conditions and group by and an order by ..
The problem is i run with particular combition of column values in where...oracle is exiting from sqlplus..(i.e disconnected)..
if i change where cluase combition which working fine...the problem is only for particular combination of where clause columns..(which more than 2 million records)..
Even i tested saperately the groupby and order by..it is working fine..
I am using 10g..really dont understand this oracle behaviour..
Please suggest...
Thanks
Onenessboy