ORA-00926: missing VALUES keyword

[#1]

Hello,

when i try to start an insert statement at a remote database I m getting the following error message:

ORA-00926: missing VALUES keyword

the statement is INSERT INTO <TABLE> VALUES(100,12,01-Dec-10,'ENTRY')

the table has the following form: COL1 (NUMC), COL2(NUMC, COL3(DATE) COl4 (VARCHAR255)

i tried to use several formats but i m not getting any solution for inserting. The user i m using has the privileges for inserting.

has anyone a solution what will be the error?

Thanks

[Former Member]

a simple error in the syntax

[Former Member]

Try this out

insert into table_name values(100,12,to_date('01-Dec-10','DD-MON-YY'),'ENTRY');

Regards

Kausik

[Former Member]

Hello together,

thanks for your help!

The ' were the problems its running fine now;)

[Former Member]

Please mark it as answered.

[fjhernanz]

Hi,

Try to use the following format instead:

INSERT INTO <table_name> (<field1>,<field2>,...) VALUES (<value1>,<value2>,...);

Br,

Javier

[Former Member]

Try using single quotes for the date part: INSERT INTO <TABLE> VALUES(100,12,'01-Dec-10','ENTRY')

Kind regards,

Mark