Hi

I got a table called S and it looks like this:

snr varchar2(5)
sname varchar2(15)
status number(10)
city varchar2(15)

When I try to do this insert:

insert into S (
snr, sname, status, city)
values(
s1, 'smith', 20, 'London')
;

I get the following error message:

ERROR at line 4:
ORA-00984: column not allowed here

What is wrong? What does this mean?

Please help me