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-00116: Duplicate where-clause in table expression



PLS-00116: Duplicate where-clause in table expression..

Answer / guest

Cause: Two or more WHERE clauses were found in a DELETE,
SELECT, or UPDATE statement. The WHERE clause specifies a
condition under which rows in a table are processed. The
condition can contain several logical expressions connected
by AND or OR, but a statement can contain only one WHERE clause.

Action: Remove one of the WHERE clauses and, if necessary,
connect logical expressions by AND or OR

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06413: Connection not open.

1 Answers  


PLS-00303: qualifier 'string' must be declared

1 Answers  


ORA-02210: no options specified for ALTER TABLE

1 Answers  


PLS-01500: Unions are not allowed in the definition of a view

1 Answers  


ORA-23316: the masterdef is string

1 Answers  


ORA-06323: IPA: Cause event error

1 Answers  


ORA-01495: specified chain row table not found

1 Answers  


PCC-01001: Your Pro*COBOL authorization is about to expire

1 Answers  


LPX-00657: Invalid output PI '~S'.

1 Answers  


ORA-28113: policy predicate has error

1 Answers  


ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.

1 Answers  


ORA-12406: unauthorized SQL statement for policy string

1 Answers  


Categories