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-12589: TNS:connection not bequeathable

1 Answers  


RMAN-06524: RMAN retention policy will be applied to the command

1 Answers  


ORA-00293: controlfile out of sync with redo log

1 Answers  


ORA-02365: error seeking in file: string

1 Answers  


ORA-00151: invalid transaction ID

1 Answers  


ORA-28044: unsupported directory type

1 Answers  


ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.

1 Answers  


ORA-30389: the source statement is not compatible with the destination statement

1 Answers  


ORA-10565: Another test recovery session is active

1 Answers  


ORA-02700: osnoraenv: error translating ORACLE_SID

1 Answers  


ORA-06043: NETDNT: message send failure

1 Answers  


ORA-30106: reserved for future use

1 Answers  


Categories