时间戳

首页 > 解决方案 > 无法将值插入表（Oracle）

sql - 无法将值插入表（Oracle）

问题描述

当我尝试将值插入表中时，我不断收到错误报告 - ORA-01722: invalid number。

我正在使用甲骨文。最初的问题是表存储的主键是表员工的外键，反之亦然，因此我无法插入任何值。所以我将表存储中的外键更改为 NULL 并尝试了但仍然没有用

create table Store(
Store_ID integer primary key,
Warehouse_ID integer not null,
Employee_ID integer,
Owner_name varchar2 (15) not null,
Store_hours varchar (10) not null,
Store_name varchar (20) not null,
Store_Address varchar2 (35) not null,
  CONSTRAINT Warehouse_FK_Store
  FOREIGN KEY (Warehouse_ID)
  REFERENCES Warehouse (Warehouse_ID),
  CONSTRAINT Employee_FK_Store
  FOREIGN KEY (Employee_ID)
  REFERENCES Employee (Employee_ID));

insert into Store
values (101, 1001, NULL , 'Grant Campbell', '7:00am - 10:00pm', 'Papakura', '331-345 Great South Road, Takanini, Auckland, 2110');

标签： sqloracleora-01722

解决方案

您的查询是正确的，但是您的 Store_Address varchar 大小太短，并且您的查询大小大于，即您需要将大小更改Store_Address varchar (35)为 Store_Address varchar (255)

   create table Store(
    Store_ID integer primary key,
    Warehouse_ID integer not null,
    Employee_ID integer,
    Owner_name varchar2 (15) not null,
    Store_hours varchar (10) not null,
    Store_name varchar (20) not null,
    Store_Address varchar2 (255) not null,
      CONSTRAINT Warehouse_FK_Store
      FOREIGN KEY (Warehouse_ID)
      REFERENCES Warehouse (Warehouse_ID),
      CONSTRAINT Employee_FK_Store
      FOREIGN KEY (Employee_ID)
      REFERENCES Employee (Employee_ID));

    insert into Store
    values (101, 1001, NULL , 'Grant Campbell', '7:00am - 10:00pm', 'Papakura', '331-345 Great South Road, Takanini, Auckland, 2110');

推荐阅读