The error message you're seeing, "ORA-02267: column type incompatible with referenced column type," is from Oracle Database. It means that the data type of the 'contact_no' column in your table doesn't match the data type of the 'contact_no' column in the 'branch' table.

Here's how you can fix this issue:

1. Check the data type of the 'contact_no' column in both tables. You can do this by running the following SQL command:

```sql
SELECT data_type
FROM user_tab_columns
WHERE table_name = 'YOUR_TABLE_NAME'
AND column_name = 'CONTACT_NO';
```
Replace 'YOUR_TABLE_NAME' with the name of your table.

2. Once you've identified the data types, alter the 'contact_no' column in your table to match the data type of the 'contact_no' column in the 'branch' table. Here's an example of how you can do this:

```sql
ALTER TABLE your_table_name
MODIFY (contact_no NEW_DATA_TYPE);
```
Replace 'your_table_name' with the name of your table, and 'NEW_DATA_TYPE' with the correct data type.

3. After you've modified the data type, try creating the foreign key constraint again. If the data types match, you should be able to create the constraint without any issues.

Question

The error message you're seeing, "ORA-02267: column type incompatible with referenced column type," is from Oracle Database. It means that the data type of the 'contact_no' column in your table doesn't match the data type of the 'contact_no' column in the 'branch' table.

Here's how you can fix this issue:

1. Check the data type of the 'contact_no' column in both tables. You can do this by running the following SQL command:

```sql
SELECT data_type 
FROM user_tab_columns 
WHERE table_name = 'YOUR_TABLE_NAME' 
AND column_name = 'CONTACT_NO';
```
Replace 'YOUR_TABLE_NAME' with the name of your table.

2. Once you've identified the data types, alter the 'contact_no' column in your table to match the data type of the 'contact_no' column in the 'branch' table. Here's an example of how you can do this:

```sql
ALTER TABLE your_table_name 
MODIFY (contact_no NEW_DATA_TYPE);
```
Replace 'your_table_name' with the name of your table, and 'NEW_DATA_TYPE' with the correct data type.

3. After you've modified the data type, try creating the foreign key constraint again. If the data types match, you should be able to create the constraint without any issues.

Knowee AI · Accepted Answer

The error message you're seeing, "ORA-02267: column type incompatible with referenced column type," is from Oracle Database. It means that the data type of the 'contact_no' column in your table doesn't match the data type of the 'contact_no' column in the 'branch' table.

Here's how you can fix this issue:

1. Check the data type of the 'contact_no' column in both tables. You can do this by running the following SQL command:

```sql
SELECT data_type 
FROM user_tab_columns 
WHERE table_name = 'YOUR_TABLE_NAME' 
AND column_name = 'CONTACT_NO';
```
Replace 'YOUR_TABLE_NAME' with the name of your table.

2. Once you've identified the data types, alter the 'contact_no' column in your table to match the data type of the 'contact_no' column in the 'branch' table. Here's an example of how you can do this:

```sql
ALTER TABLE your_table_name 
MODIFY (contact_no NEW_DATA_TYPE);
```
Replace 'your_table_name' with the name of your table, and 'NEW_DATA_TYPE' with the correct data type.

3. After you've modified the data type, try creating the foreign key constraint again. If the data types match, you should be able to create the constraint without any issues.

constraint fk_contact_no foreign key(contact_no) references branch(contact_no) * ERROR at line 6: ORA-02267: column type incompatible with referenced column type

Question

Solution

Similar Questions

Upgrade your grade with Knowee