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-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

1 Answers  


ORA-06258: NETNTT: cannot allocate context area

1 Answers  


CLSR-00517: Failed to register a service name

1 Answers  


PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


PCB-00215: OCCURS TO TIMES clause not allowed for host variable "string"

1 Answers  


ORA-29518: name string resolved to an object in schema string that is not a Java class

1 Answers  


ORA-16058: standby database instance is not mounted

1 Answers  


ORA-17502: ksfdcre:string Failed to create file string

1 Answers  


ORA-07483: snlkget: cannot convert(get) lock.

1 Answers  


RMAN-08006: database registered in recovery catalog

1 Answers  


TNS-00296: Stoppable : string

1 Answers  


ORA-28651: Primary index on IOTs can not be marked unusable

1 Answers  


Categories