Run a 10046 trace to see where you are waiting.
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 2:21 PM
To: [email protected]
Subject: SQL Query Question
Hello Everyone:
Thanks to all who have responded to my question about
Chris:
Thanks for your response. The reason I think this might be a DBI/DBD
question is that the SQL works in under 1 second from locally-connected
SQL*Plus, remote-connected SQL*Plus, and TOAD. Only in Perl is it going
away and never returning. I have tried setting SQL_TRACE; no joy. I've
tr
Michael,
First, it's unlikely this is on-topic for the list either. There are
at least 2 mailing lists, both apparently
still active, which have had good Oracle experts as members, at least
as of a few years ago.
http://www.freelists.org/webpage/oracle-l
http://www.lazydba.com/
I am no lo
Hello
Everyone:
Thanks to all who
have responded to my question about logging. That got me to the
problematic SQL. This SQL,
on just one
instance, hangs and does not complete. I have let it run for hours to no
avail. When I run this
query at SQL*Plus I
get...
'OKAY'--
on 08/23/2001
02:34:06 PM
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: RE: SQL Query Question
select company,carrier from customers
where this_month = (select max(this_month) from customers)
and carrier = 'QW
select company,carrier from customers
where this_month = (select max(this_month) from customers)
and carrier = 'QWEST'
-Original Message-
From: Jeff Eckermann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 11:28 AM
To: Isaac; [EMAIL PROTECTED]
Subject: Re: SQL Quer
You need to add "GROUP BY Company" to the end of your SQL statement.
I find that easy to forget, but the now-familiar error messages help!
- Original Message -
From: "Isaac" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 12:5
Hello,
I am not a db programmer so please excuse this probably simple question but
I can't seem to figure it out.
There is an Access 2000 database and inside this database there is a table
called Customers.
Customers has various columns and three of those are called Company,
ThisMonth and Carr
