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-13709: Required parameter "string" must be set before execution.

1 Answers  


ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.

1 Answers  


PLS-01416: Use of <id> (<value>...) here

1 Answers  


ORA-31053: The value of the depth argument in the operator cannot be negative

1 Answers  


IMG-00833: boundary queue size exceeds expected size

1 Answers  


ORA-31090: invalid database schema name "string"

1 Answers  


ORA-09748: pws_look_up: fork failed

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


TNS-00270: %s: Terminal Error string

1 Answers  


ORA-02315: incorrect number of arguments for default constructor

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  


ORA-25146: EXTENT MANAGEMENT option already specified

1 Answers  


Categories