PLS-00518: This INSERT statement requires VALUES clause containing a parenthesi

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

Question Posted / guest

1 Answers
3145 Views
I also Faced
E-Mail Answers

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