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...


PLS-00423: ORDER BY item must be the number of a SELECT-list
expression



PLS-00423: ORDER BY item must be the number of a SELECT-list expression..

Answer / guest

Cause: A column alias was used in the ORDER BY clause of a
SELECT statement that uses a UNION, INTERSECT, or MINUS set
operator. This is not allowed. In such cases, expressions in
the ORDER BY clause must be unsigned integers that designate
the ordinal positions of select-list items.

Action: Change the alias in the ORDER BY clause to an
unsigned integer that designates the ordinal position of the
select item in question.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01073: materialized view, string, has a join not found in query

1 Answers  


ORA-28104: input value for string is not valid

1 Answers  


ORA-02777: Stat failed on log directory

1 Answers  


TNS-04072: Unable to suspend atleast one of the gateways.

1 Answers  


IMG-00712: unable to write to destination image

1 Answers  


ORA-13462: invalid blocking specification

1 Answers  


ORA-00032: invalid session migration password

1 Answers  


ORA-13430: the GeoRaster object has null attribute(s)

1 Answers  


ORA-06923: CMX: illegal break condition

1 Answers  


ORA-07573: slkhst: could not perform host operation

1 Answers  


O2I-00129: No Java file specified

1 Answers  


ORA-01353: existing Logminer session

1 Answers  


Categories