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-01610: a lossy join in equivalence, string, between tables, string, not found in query

1 Answers  


TNS-02514: Invalid packet received

1 Answers  


ORA-06900: CMX: cannot read tns directory

1 Answers  


ORA-02300: invalid value for OIDGENERATORS

1 Answers  


ORA-24322: unable to delete an initialized mutex

1 Answers  


ORA-12026: invalid filter column detected

1 Answers  


DRG-11860: Connection Establishment Interrupted

1 Answers  


LSX-00164: no content specified in "~S"

1 Answers  


ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed

1 Answers  


ORA-06575: Package or function string is in an invalid state

1 Answers  


ORA-24440: OCI Easy Install mode cannot be initialized

1 Answers  


ORA-14062: one or more of table's partitions reside in a read-only tablespace

1 Answers  


Categories