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-24801: illegal parameter value in OCI lob function

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  


ORA-22315: type "string" does not contain a map or order function

1 Answers  


SQL*Loader-00933: Specified file string not part of database

1 Answers  


ORA-06601: LU6.2 Driver: Invalid database ID string

1 Answers  


ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

1 Answers  


ORA-24814: operation not allowed for temporary LOBs

1 Answers  


ORA-19716: error processing format string to generate name for backup

1 Answers  


ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

1 Answers  


ORA-31430: subscriber view exists

1 Answers  


ORA-38736: Wrong thread number string in flashback log file header.

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  


Categories