ORA-00907:missing right parenthesis

1. Error description

2. Error reason

create table t_stu_info(
    id int(10) primary key,
    name varchar2(20) not null
 );

Error, missing close parenthesis, int(10)

3. Solutions

create table t_stu_info(
    id int primary key,
    name varchar2(20) not null
 );

After removing the length of the data type after ID, no error will be reported; The ID data type length was also bracketed, but the Oracle client still prompts for an error


Read More: