MSSQL 迁移 oracle
CREATE TABLE STUDENT ( ID NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY, NAME VARCHAR2(50) NOT NULL, AGE NUMBER(3) NOT NULL, GENDER NUMBER(1) NOT NULL, SCORE FLOAT(2) NOT NULL, CREATE_TIME TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL, CONSTRAINT PK_STUDENT PRIMARY KEY (ID) ); ALTER TABLE STUDENT ADD CONSTRAINT CK_STUDENT_SCORE CHECK (SCORE >= 0 AND SCORE
