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

LPX-00100: root element "~1S" does not match DTD root "~2s"

1 Answers  


LPX-00663: VM String-Stack overflow.

1 Answers  


ORA-24168: rule string.string cannot have default evaluation context

1 Answers  


ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views

1 Answers  


ORA-13442: GeoRaster metadata SRS error

1 Answers  






ORA-01156: recovery in progress may need access to files

2 Answers  


ORA-26523: rpc termination error

1 Answers  


ORA-00360: not a logfile member: string

1 Answers  


ORA-39308: application/database upgrade internal error: "string"

1 Answers  


ORA-02839: Sync of blocks to disk failed.

1 Answers  


ORA-26534: collision: tranID number ignored and purged

1 Answers  


ORA-13910: Parameter string cannot be NULL.

1 Answers  


Categories