sql - Why am I receiving "not enough values" when running an INSERT?

Question

Couldn't get the right approach to automatically set the id value in my table with Oracle. Here's my trigger:

create or replace trigger themes_on_insert
before insert on THEME
for each row
begin
   :new.ID := THEMES_SEQ.nextval;
end;

I have two columns: id, description. But when i call insert

insert into theme values('Sport');

it gives me

Error report: SQL Error: ORA-00947: not enough values 00947. 00000 - "not enough values"

Answer 1

You do not specify the columns you are supplying values for, so the database expects a value for every column in your table.

Assuming you have a column name in that table, you need to do this:

insert into theme (name) values('Sport');

Not listing the target columns in an INSERT statement is bad coding style.