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!