Home » SQL & PL/SQL » SQL & PL/SQL » Count of error messages
Count of error messages [message #230984] Fri, 13 April 2007 11:15 Go to next message
marks20101
Messages: 74
Registered: May 2005
Member
ERR_LOG_PID NOT NULL NUMBER(10)
PROCESS_RUN_PID NOT NULL NUMBER(10)
ERR_SVRTY_CODE_PID NUMBER(10)
ERR_SRC_SYS_CODE_PID NUMBER(10)
ERR_RPT_GRP_CODE_PID NUMBER(10)
ERR_TS NOT NULL DATE
SQL_ERR_MSG VARCHAR2(2000)
LOCAL_ERR_MSG VARCHAR2(2000)

How can I get a count of the total different messages, err_log_pid is for the whole log.
Re: Count of error messages [message #230993 is a reply to message #230984] Fri, 13 April 2007 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What define a distinct message?

Regards
Michel
Re: Count of error messages [message #230999 is a reply to message #230984] Fri, 13 April 2007 11:58 Go to previous message
marks20101
Messages: 74
Registered: May 2005
Member
Yes and the count on the messages.. I was using this...

select local_err_msg,
count(process_run_pid) over (partition by process_run_pid order by process_run_pid) total
from err_log
WHERE TRUNC(ERR_TS) = TO_DATE('13-APR-07','DD-MON-YY')
order by process_run_pid

I'll get back with more details(lay out of the data) tonight...thanks

[Updated on: Fri, 13 April 2007 13:48]

Report message to a moderator

Previous Topic: Nested SELECT??? and MINUS/NEST - stumped!!!! (merged 2 threads)
Next Topic: how to wite this query?
Goto Forum:
  


Current Time: Sat Dec 10 18:11:35 CST 2016

Total time taken to generate the page: 0.13401 seconds