I'm curious whether your script can be completed successfully, which means it's better to change the int type of your table creation script to number(8).

Then there is nothing wrong with your grammar. It can be successful under sql server. Oracle doesn't express your constraints like this.