create table EMPLOYEES
(
EMPLOYEE_ID NUMBER(6) PRIMARY KEY,
FIRST_NAME VARCHAR2(20) DEFAULT NULL,
LAST_NAME VARCHAR2(25),
EMAIL VARCHAR2(25),
PHONE_NUMBER VARCHAR2(20) DEFAULT NULL,
HIRE_DATE DATE(7),
JOB_ID VARCHAR2(10),
SALARY NUMBER(8,2) DEFAULT NULL,
COMISSION_PCT NUMBER(2,2) DEFAULT NULL,
MANAGER_ID NUMBER(6) DEFAULT NULL,
DEPARTMENT_ID NUMBER(4) DEFAULT NULL
);
This is what I want to create (constraints and other information)
1条答案
按热度按时间rxztt3cl1#
date数据类型不接受长度,所以不需要写date(7),只需简单地写date,然后运行desc EMPLOYEES命令;它将显示日期长度默认为7。