PLS-00518: This INSERT statement requires VALUES clause
containing a parenthesised list of values



PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values..

Answer / guest

Cause: A VALUES clause was entered without a list of SQL
data items in parentheses. In all INSERT statements with an
explicit column list, the VALUES clause must contain a list
of SQL data items in parentheses. For example: INSERT INTO
my_tab (a,b,c) VALUES (1,2,my_variable);

Action: Rewrite the statement to include a list of SQL data
items in parentheses.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19688: control file autobackup format(string) for string does not have %F

1 Answers  


ORA-22628: OCIAnyData already constructed

1 Answers  


ORA-13442: GeoRaster metadata SRS error

1 Answers  


ORA-30204: buffer is not large enougth

1 Answers  


ORA-19553: device name string is invalid

1 Answers  






NNO-00254: warning: parameter string value must be between number and number, set to number seconds

1 Answers  


ORA-38420: invalid stored attribute sub-expression: string

1 Answers  


SQL*Loader-00410: Number to skip must be load-level, not table-level

1 Answers  


RMAN-10015: error compiling PL/SQL program

1 Answers  


ORA-13825: missing SQL statement text for create SQL profile

1 Answers  


RMAN-06547: tablespace SYSTEM cannot be excluded from whole database backup

1 Answers  


ORA-38713: Flashback Database logging is already turned on.

1 Answers  


Categories