Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-30486: invalid window aggregation group in the window
specification



ORA-30486: invalid window aggregation group in the window specification..

Answer / guest

Cause: If the window specification is specified using RANGE
option and there are multiple ORDER BY expressions, then the
aggregation group cannot contain any expression (It can only
have CURRENT ROW, UNBOUNDED PRECEDING, or UNBOUNDED
FOLLOWING). First end point (bound) cannot be UNBOUNDED
FOLLOWING and second end point cannot be UNBOUNDED
PRECEDING. If the first end point is CURRENT ROW, then
second end point can only be CURRENT ROW or <expr>
/UNBOUNDED FOLLOWING. If the first end point is <expr>
FOLLOWING, then second end point can only be
<expr>/UNBOUNDED FOLLOWING.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00109: unknown exception name 'string' in PRAGMA EXCEPTION_INIT

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


TNS-12229: TNS:Interchange has no more free connections

1 Answers  


QSM-02180: no primary key constraint in the master table

1 Answers  


ORA-29903: error in executing ODCIIndexFetch() routine

1 Answers  


PCC-02205: Parser error at line number, column number, file string:

1 Answers  


AMD-00137: prefix "string" exceeds maximum permitted length of string characters

1 Answers  


TNS-04044: Specified gateways do not exist.

1 Answers  


ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 Answers  


NNL-00229: Request-processing delay is now disabled

1 Answers  


ORA-15073: diskgroup string is mounted by another ASM instance

1 Answers  


ORA-04092: cannot string in a trigger

1 Answers  


Categories