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-12431: invalid audit action

1 Answers  


ORA-31006: Path name segment length string exceeds maximum length string

1 Answers  


SQL*Loader-00623: second enclosure string not present

1 Answers  


NNL-00541: set|show trace_level [<level>] [<server_list>] : set|show the server's tracing level

1 Answers  


ORA-12069: invalid object for offline instantiation

1 Answers  






SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number

1 Answers  


TNS-12227: TNS:syntax error

1 Answers  


QSM-01116: window function computability checks failed

1 Answers  


ORA-00366: log string of thread string, checksum error in the file header

1 Answers  


ORA-29269: HTTP server error string

1 Answers  


DRG-12700: seed word must be a single word

1 Answers  


ORA-31050: Access denied

1 Answers  


Categories