Re: Can anyone help me
Looks like the initial comma after the left paren is your problem (VALUES(,'somevalue')- you need to have either NULL or a value as the first value or, if you only want to insert partial column (say, with auto-incremented column as the first column), you need to list the columns to update:
insert into subscribers (col1, col2, col3) values (1,2,3)
an 'empty' placeholder is not valid SQL syntax (in any db system)-
-kelly
Subject
Written By
Posted
Re: Can anyone help me
May 02, 2005 05:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.