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

ORA-16034: FROM parameter is incompatible with MANAGED recovery

1 Answers  


LSX-00103: duplicate group "~S"

1 Answers  


ORA-19657: cannot inspect current datafile string

1 Answers  


ORA-30659: too many locations specified for external table

1 Answers  


RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset

1 Answers  


ORA-07628: smsfre: sga not mapped

1 Answers  


ORA-38419: invalid identifier in attribute : string

1 Answers  


ORA-13266: error inserting data into table string

1 Answers  


ORA-22913: must specify table name for nested table column or attribute

1 Answers   ABC,


ORA-28665: table and partition must have same compression attribute

1 Answers  


RMAN-08070: deleted datafile copy

1 Answers  


ORA-34363: (MXDSS13) number other user writing

1 Answers  


Categories