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

TNS-12655: Password check failed

1 Answers  


ORA-12622: TNS:event notifications are not homogeneous

1 Answers  


TNS-01052: The command completed successfully

1 Answers  


ORA-24314: service handle not initialized

1 Answers  


ORA-25445: invalid column number: string for table alias: string

1 Answers  


ORA-13009: the specified date string is invalid

1 Answers  


ORA-06251: NETNTT: cannot translate address file name

1 Answers  


ORA-01891: Datetime/Interval internal error

1 Answers  


ORA-14036: partition bound value too large for column

1 Answers  


NID-00507: APPEND Append to output log NO

1 Answers  


RMAN-06300: Report of files with less than number redundant backups

1 Answers  


NNL-00536: set|show requests_enabled [<on|off>] [<server_list>] : enable, disable or show server request processing

1 Answers  


Categories