将值插入A列 [英] Inserting values Into A column

问题描述

我知道这是这样做的方式:

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.

这是表格信息:

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  -   -

推荐答案

INSERT  INTO harmeier
        (
          STUDENT_ID,
          LAST_NAME,
          FIRST_NAME,
          CREDITS,
          GRADUATION_DATE
        )
VALUES  (
          23216,
          'Harmeier',
          'Cory',
          45,
          to_date('20130502', 'yyyymmdd')
        );

这篇关于将值插入A列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！