Skip to content
Home » Oracle » How to Resolve ORA-02263: need to specify the datatype for this column

How to Resolve ORA-02263: need to specify the datatype for this column

ORA-02263

Tried to create a table, but it failed with ORA-02263.

SQL> create table fruits (fruit_name not null, price number);
create table fruits (fruit_name not null, price number)
                     *
ERROR at line 1:
ORA-02263: need to specify the datatype for this column

ORA-02263 means that the one you specified in the column list does not have any valid data type, you should check the statement, then create again.

In this case, we forgot to specify the data type for the first column. Let's correct and do it again.

SQL> create table fruits (fruit_name varchar2(20) not null, price number);

Table created.

We fixed it!

Leave a Reply

Your email address will not be published. Required fields are marked *