Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-30484 aliasing analytics column

ORA-30484 aliasing analytics column

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Mon, 11 Apr 2005 10:40:48 -0500
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE66970235EA@QTEX1.qg.com>


I'm running an analytical SELECT in 9.2.0.4.0 under 9.2.0.6.0 SQL*Plus:

SELECT first_time, first_time - LAG(first_time) OVER (ORDER BY first_time)=20
FROM v$log_history;

And it works as expected. However, if I try to alias the second column:

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

It blows up with "ORA-30484: missing window specification for this = function".

Huh? There's gotta be something obvious I'm missing here.

TIA,
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

Disclaimer: Where's my old classmate, Alan?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 11 2005 - 11:43:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US