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

PCB-00637: Host variable is not an exact binary integer

1 Answers  


PCC-02426: Incompatible LOB types

1 Answers  


QSM-00760: the import mode string is invalid for the current operation

1 Answers  


PCB-00108: Unable to open list file "string"

1 Answers  


ORA-09879: sstascre/sstasat: shmat error, unable to attach tas read page

1 Answers  


ORA-02051: another session in same transaction failed

1 Answers   Axede,


LPX-00220: the string "]]>" cannot occur in character data

1 Answers  


ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.

1 Answers  


NNL-00516: Displays complete server status

1 Answers  


ORA-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events

1 Answers  


QSM-02138: agg(expr) requires correspondng agg(expr*expr) function

1 Answers  


ORA-07757: slemcc: invalid handle

1 Answers  


Categories