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


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

PCC-02428: Buffer type is incompatible with LOB type

1 Answers  


NZE-29105: Cannot export PKCS #12 wallet.

1 Answers  


PCC-02330: expecting an expression of integer type

1 Answers  


ORA-32310: object materialized views must select from an object table

1 Answers  


ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index

1 Answers  






RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

1 Answers  


SQL*Loader-00640: Variable length field was truncated.

1 Answers  


ORA-06741: TLI Driver: unable to open protocol device

1 Answers  


ORA-30625: method dispatch on NULL SELF argument is disallowed

1 Answers  


ORA-02368: file string is not valid for this load operation

1 Answers  


RMAN-00572: waiting for dbms_pipe input

1 Answers  


NNL-00267: Address is string

1 Answers  






Categories