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

ORA-07489: scgrcl: cannot get lock status.

1 Answers  


ORA-16733: Error executing dbms_logstdby.unskip procedure

1 Answers  


ORA-14612: Duplicate lob segment name string for lob column string in template

1 Answers  


DRG-50919: NEAR operand not a phrase, equivalence or another NEAR expression

1 Answers  


ORA-08275: Environment variable unset

1 Answers  


IMP-00047: unexpected file sequence number; expected number but found number

1 Answers  


IMG-00716: source image format does not support process options

1 Answers  


ORA-15048: ASM internal files cannot be deleted

1 Answers  


ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

1 Answers  


AMD-00106: parent string "string" must be removed before child string "string" can be removed

1 Answers  


ORA-06973: X.25 Driver: invalid buffer size

1 Answers  


PLS-00491: numeric literal required

1 Answers  


Categories