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

CLSS-00200: local node string not listed in configuration

1 Answers  


ORA-02461: Inappropriate use of the INDEX option

1 Answers  


QSM-00767: a SQL cache is not available to user string

1 Answers  


ORA-06924: CMX: wrong break message length

1 Answers  


ORA-30929: ORDER SIBLINGS BY clause not allowed here

1 Answers  


TNS-00134: Missing COMMUNITY component in addresses for the Navigator in TNSNAV.ORA

1 Answers  


KUP-02006: script line too long

1 Answers  


RMAN-08549: database name (or lock name space) used for search: string

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


ORA-19323: Invalid url string

1 Answers  


DRG-10517: index string is already valid

1 Answers  


ORA-16169: LGWR network server invalid parameters

1 Answers  


Categories