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-00486: select list cannot be enclosed in parentheses



PLS-00486: select list cannot be enclosed in parentheses..

Answer / guest

Cause: In a SELECT statement, the select list was enclosed
in parentheses, as in: SELECT (deptno, dname, loc) FROM dept
INTO ... This breaks the rules of SQL syntax. Parentheses
are not required because the keywords SELECT and FROM
delimit the select list.

Action: Remove the parentheses enclosing the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29287: invalid maximum line size

1 Answers  


ORA-16040: standby destination archive log file is locked

1 Answers  


RMAN-06481: WARNING: backup piece 'string' cannot be found on the storage medium

1 Answers  


NZE-28822: Required seed is not specified.

1 Answers  


ORA-06806: TLI Driver: could not complete protocol initialization for SPX

1 Answers  


QSM-02173: the unique constraints does not exist on the join columns of the inner table

1 Answers  


ORA-12429: label list range exceeded

1 Answers  


ORA-01615: instance string (thread string) is mounted - cannot disable

1 Answers  


LRM-00116: syntax error at 'string' following 'string'

1 Answers  


ORA-24306: bad buffer for piece

1 Answers  


ORA-07426: spstp: cannot obtain the location of dbs directory.

1 Answers  


ORA-38900: missing mandatory column "string" of error log table "string"

1 Answers  


Categories