Originally posted by Swapna Gouri Kalanidhi:
Here's the rectified code Vijitha
Will be very grateful to you if you can help me in solving this problem...
There are two forms for a SQL insert statement.
The first form doesn't specify the column names where the data will be inserted, only their values (you insert all the columns in order):
This seems to be the format of your statement. However, you're still not including the VALUES clause before your column values. Add the VALUES clause before your parentheses and make sure you're have all your columns specified in order.
The second form specifies both the column names and the values to be inserted:
Use this one if you're not including all the columns... and don't forget your VALUES clause.