Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00917: missing comma. HELP!!!!!!!!!!!!!!!!!!!!!!!!

980595Dec 18 2012 — edited Dec 18 2012
Hi, I am trying to insert data into a table which I created but I keep getting the error: missing comma. Could you please take a look at my coding and tell me where I have missed the comma.

INSERT INTO EMPLOYEE_DATA

(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPARTMENT, SALARY_(£), SALARY_PAIDON)

VALUES
('1', 'David', 'Smith', 'IT', '20,000', '3/11/2012')
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2013
Added on Dec 18 2012
12 comments
12,892 views