The error message you're receiving is indicating that there is a missing right parenthesis in your SQL command. However, from the command you've provided, the parentheses seem to be balanced.

The issue might be related to the way you've written your constraints. In Oracle SQL, you don't need to specify the column name when you're creating a foreign key constraint if the primary key is a single column.

Here's how you can modify your command:

```sql
CREATE TABLE CROP(
CROP_ID NUMBER PRIMARY KEY,
CROP_NAME VARCHAR2(100) NOT NULL,
PLANTING_DATE DATE NOT NULL,
FIELD_ID NUMBER NOT NULL,
CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD,
CONSTRAINT FK_FIELD_CONDITION_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD
)
```

In this command, I've removed the `(FIELD_ID)` after `REFERENCES FIELD` in your constraints. If `FIELD_ID` is the primary key in the `FIELD` table, Oracle SQL will automatically know that your foreign key is referencing it.

If `FIELD_ID` is not the primary key in the `FIELD` table, you need to specify it like this:

```sql
CREATE TABLE CROP(
CROP_ID NUMBER PRIMARY KEY,
CROP_NAME VARCHAR2(100) NOT NULL,
PLANTING_DATE DATE NOT NULL,
FIELD_ID NUMBER NOT NULL,
CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD(FIELD_ID),
CONSTRAINT FK_FIELD_CONDITION_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD(FIELD_ID)
)
```

Please replace `FIELD` with your actual table name if it's different.

Question

The error message you're receiving is indicating that there is a missing right parenthesis in your SQL command. However, from the command you've provided, the parentheses seem to be balanced.

The issue might be related to the way you've written your constraints. In Oracle SQL, you don't need to specify the column name when you're creating a foreign key constraint if the primary key is a single column.

Here's how you can modify your command:

```sql
CREATE TABLE CROP(
    CROP_ID NUMBER PRIMARY KEY,
    CROP_NAME VARCHAR2(100) NOT NULL,
    PLANTING_DATE DATE NOT NULL,
    FIELD_ID NUMBER NOT NULL,
    CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD,
    CONSTRAINT FK_FIELD_CONDITION_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD
)
```

In this command, I've removed the `(FIELD_ID)` after `REFERENCES FIELD` in your constraints. If `FIELD_ID` is the primary key in the `FIELD` table, Oracle SQL will automatically know that your foreign key is referencing it.

If `FIELD_ID` is not the primary key in the `FIELD` table, you need to specify it like this:

```sql
CREATE TABLE CROP(
    CROP_ID NUMBER PRIMARY KEY,
    CROP_NAME VARCHAR2(100) NOT NULL,
    PLANTING_DATE DATE NOT NULL,
    FIELD_ID NUMBER NOT NULL,
    CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD(FIELD_ID),
    CONSTRAINT FK_FIELD_CONDITION_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD(FIELD_ID)
)
```

Please replace `FIELD` with your actual table name if it's different.

Knowee AI · Accepted Answer

The error message you're receiving is indicating that there is a missing right parenthesis in your SQL command. However, from the command you've provided, the parentheses seem to be balanced.

The issue might be related to the way you've written your constraints. In Oracle SQL, you don't need to specify the column name when you're creating a foreign key constraint if the primary key is a single column.

Here's how you can modify your command:

```sql
CREATE TABLE CROP(
    CROP_ID NUMBER PRIMARY KEY,
    CROP_NAME VARCHAR2(100) NOT NULL,
    PLANTING_DATE DATE NOT NULL,
    FIELD_ID NUMBER NOT NULL,
    CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD,
    CONSTRAINT FK_FIELD_CONDITION_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD
)
```

In this command, I've removed the `(FIELD_ID)` after `REFERENCES FIELD` in your constraints. If `FIELD_ID` is the primary key in the `FIELD` table, Oracle SQL will automatically know that your foreign key is referencing it.

If `FIELD_ID` is not the primary key in the `FIELD` table, you need to specify it like this:

```sql
CREATE TABLE CROP(
    CROP_ID NUMBER PRIMARY KEY,
    CROP_NAME VARCHAR2(100) NOT NULL,
    PLANTING_DATE DATE NOT NULL,
    FIELD_ID NUMBER NOT NULL,
    CONSTRAINT FK_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD(FIELD_ID),
    CONSTRAINT FK_FIELD_CONDITION_FIELD_ID FOREIGN KEY (FIELD_ID) REFERENCES FIELD(FIELD_ID)
)
```

Please replace `FIELD` with your actual table name if it's different.

Question

Solution

Similar Questions

Upgrade your grade with Knowee