oracle - “缺少右括号”错误 - Oracle

Question

当我创建此代码时：

SQL> create table TRANSAKSI_9223(
  2  ID_Transaksi number(13)
  3  constraint idtransaksi_pk primary key,
  4  Tgl_Transaksi date constraint tgl_notnull not null,
  5  Total_harga float,
  6  id_pembeli number(13), constraint fk_idpembeli references PEMBELI_9223(id_pembeli));
id_pembeli number(13), constraint fk_idpembeli references PEMBELI_9223(id_pembeli))
                                                                      *
ERROR at line 6:
ORA-00907: missing right parenthesis

我应该怎么办？

标签： oracleforeign-keysddl

Answer 1

您缺少列名

    CONSTRAINT FK_PersonOrder FOREIGN KEY (columnename)
    REFERENCES  PEMBELI_9223(id_pembeli);