PLS-00486: select list cannot be enclosed in parentheses
- 1 Answers
- 2495 Views
- I also Faced
- E-Mail Answers
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 |
ORA-01632: max # extents (string) reached in index string.string
ORA-25301: cannot specify recipient list during enqueue
ORA-01867: the interval is invalid
TNS-12656: Cryptographic checksum mismatch
ORA-01527: error while reading file
ORA-13831: SQL profile name specified is invalid
NPL-00418: received malformed ASN.1 object identifier
ORA-30396: rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
ORA-06438: ssaio: the asynchronous read was unable to read from the database file.
PCC-01006: EXEC statement cannot begin in Area A at line number in file string
ORA-13249: %s
ORA-25284: Invalid value string for string
Oracle Errors 
