sql - Inserting values Into A column

Question

I know that this is the way to do it:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

But when I am trying to insert values into my table:

INSERT INTO harmeier
VALUES (23216,"Harmeier", "Cory", 45, '20130502');

It is saying column not allowed here.

here is table info:

STUDENT_ID  NUMBER(6,0) Yes  -   -
LAST_NAME   VARCHAR2(255)   Yes  -   -
FIRST_NAME  VARCHAR2(255)   Yes  -   -
CREDITS NUMBER(3,0) Yes  -   -
GRADUATION_DATE DATE    Yes  -   -

Answer 1

Use single quotes:

INSERT
INTO    harmeier
VALUES  (23216, 'Harmeier', 'Cory', 45, '20130502');

Double quotes are used to delimit identifiers, not mark string constants.