Prev: nmeo.exe
Next: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small
From: Lionel on 7 Jul 2006 05:51
DA Morgan wrote:
> Lets see one non-aggregated column
> One aggregated column ... COUNT(...)
> No GROUP BY clause
>
> I wonder what could be the problem. ;-)

oops sorry...
Of course there is a "group by a.column1" in my statement :)
The statement works fine and quickly.
I was just wondering why my jdbc drivers displays a warning and how I could
see the warning under sql*plus or toad.



From: DA Morgan on 7 Jul 2006 14:34
Lionel wrote:
> DA Morgan wrote:
>> Lets see one non-aggregated column
>> One aggregated column ... COUNT(...)
>> No GROUP BY clause
>>
>> I wonder what could be the problem. ;-)
>
> oops sorry...
> Of course there is a "group by a.column1" in my statement :)
> The statement works fine and quickly.
> I was just wondering why my jdbc drivers displays a warning and how I could
> see the warning under sql*plus or toad.

As the warning is a JDBC warning you can not see it under a product not
using that JDBC connection/driver.
--
Daniel A. Morgan
University of Washington
damorgan(a)x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
First  |  Prev  | 
Pages: 1 2
Prev: nmeo.exe
Next: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small