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-01424: Non-ANSI order of clauses



PLS-01424: Non-ANSI order of clauses..

Answer / guest

Cause: ANSI specifies an ordering to clauses in a
table-expression which PL/SQL doesn't. The ordering
according to ANSI must be: (1) from clause (2) where clause
(3) group-by clause (4) having clause In PL/SQL, the from
clause must come first, and the clauses after it can appear
in any order (with the addition of the non-ansi connect-by
clause).

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23449: missing user name

1 Answers  


ORA-24346: cannot execute without binding variables

1 Answers  


ORA-15007: name is already used by an existing template

1 Answers  


ORA-00568: Maximum number of interrupt handlers exceeded

1 Answers  


NNL-00565: set trace_file_name [<filename>] [<server_list>] : set|show the server's trace file name

1 Answers  


ORA-30430: list does not contain any valid summaries

1 Answers  


DRG-11515: not enough text key values

1 Answers  


ORA-01935: missing user or role name

2 Answers  


ORA-00206: error in writing (block string, # blocks string) of controlfile

1 Answers  


ORA-14605: Name missing for subpartition / lob segment in template

1 Answers  


ORA-01680: unable to extend LOB segment by string in tablespace string

1 Answers  


ORA-27060: could not set close-on-exec bit on file

1 Answers  


Categories