Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-12512: invalid stop class string

1 Answers  


NID-00415: Change of database name and database ID failed.

1 Answers  


PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

1 Answers  


ORA-12802: parallel query server lost contact with coordinator

1 Answers  


ORA-16623: stale DRC UID sequence number detected

1 Answers  






ORA-02216: tablespace name expected

2 Answers  


EXP-00092: Unable to set NLS_NUMERIC_CHARACTERS to required defaults.

1 Answers  


ORA-12910: cannot specify temporary tablespace as default tablespace

1 Answers  


ORA-16228: Insufficient recovery for logical standby

1 Answers  


DRG-11873: System Call Replies

1 Answers  


TNS-01159: Internal connection limit has been reached; listener has shut down

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  






Categories