SQL Language (MOSC)

MOSC Banner

ora-00937

edited Sep 29, 2010 2:34AM in SQL Language (MOSC) 10 commentsAnswered
Hi,

Please tell me the correct syntax to be modified for below error:-- 

select to_char(end_interval_time, 'MM/DD/YYYY') "Date",
       sum(a.time_waited_micro)/sum(a.total_waits)/10000 c1,
  2    3         sum(b.time_waited_micro)/sum(b.total_waits)/10000 c2,
  4         (sum(a.total_waits) / sum(a.total_waits + b.total_waits)) * 100 c3,
  5         (sum(b.total_waits) / sum(a.total_waits + b.total_waits)) * 100 c4,
  6         (sum(b.time_waited_micro)/sum(b.total_waits)) /
  7  (sum(a.time_waited_micro)/sum(a.total_waits)) * 100 c5
  8  from dba_hist_system_event a, dba_hist_system_event b, dba_hist_snapshot c

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center