-- Create table
create table TEST
(
OWNER VARCHAR2(30) not null,
OBJECT_NAME VARCHAR2(30) not null,
SUBOBJECT_NAME VARCHAR2(30),
OBJECT_ID NUMBER not null,
DATA_OBJECT_ID NUMBER,
OBJECT_TYPE VARCHAR2(18),
CREATED DATE not null,
LAST_DDL_TIME DATE not null,
TIMESTAMP VARCHAR2(19),
STATUS VARCHAR2(7),
TEMPORARY VARCHAR2(1),
GENERATED VARCHAR2(1),
SECONDARY VARCHAR2(1)
);
alter table TEST
add constraint PK_TEST primary key (OWNER);
create index IN_TESTDB on TEST (OBJECT_NAME);
create table TEST
(
OWNER VARCHAR2(30) not null,
OBJECT_NAME VARCHAR2(30) not null,
SUBOBJECT_NAME VARCHAR2(30),
OBJECT_ID NUMBER not null,
DATA_OBJECT_ID NUMBER,
OBJECT_TYPE VARCHAR2(18),
CREATED DATE not null,
LAST_DDL_TIME DATE not null,
TIMESTAMP VARCHAR2(19),
STATUS VARCHAR2(7),
TEMPORARY VARCHAR2(1),
GENERATED VARCHAR2(1),
SECONDARY VARCHAR2(1)
);
alter table TEST
add constraint PK_TEST primary key (OWNER);
create index IN_TESTDB on TEST (OBJECT_NAME);
employee_id number(7) primary key, -- 主键
last_name varchar2(30),
first_name varchar2(30),
join_date date default sysdate, -- 默认值
job varchar2(15),
department_id number(3) not null -- 外键
constraint dept_fkey references department(dept_id));-- indexcreate index idx_employee_id on employee(employee_id)
tablespace users;