Re: insert on oracle db question

From: BD <bobby_dread_at_hotmail.com>
Date: 14 Mar 2006 13:55:45 -0800
Message-ID: <1142373345.914680.23880@j52g2000cwj.googlegroups.com>

>a column name is not authorised here

I think that what Anurag is trying to tell you is that you need to get single quotation marks around your SPINACH value. Here is the distinction:

INSERT INTO VEGETABLES VALUES (SPINACH) -> this tries to find a variable or another column name called SPINACH, and insert its values into the vegetables table.

INSERT INTO VEGETABLES VALUES ('SPINACH') -> this tries to insert the word SPINACH into the vegetables table.

Get your code to put single quotes around what you are inserting, and I think that should help.

BD Received on Tue Mar 14 2006 - 15:55:45 CST