Re: ORA-30484 aliasing analytics column

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Mon, 11 Apr 2005 08:41:47 -0700 (PDT)
Message-ID: <20050411154147.34471.qmail@web52609.mail.yahoo.com>

It should be:

SELECT first_time, first_time - LAG(first_time) OVER (ORDER BY first_time) "SECONDS"
FROM v$log_history;

Regards,
Zoran                 

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 11 2005 - 11:45:47 CDT