- Create a schema called "DEVELOP"
- Create a table with constraints
CREATE TABLE DEVELOP.TEST240104
(
ID NUMBER,
INFO_NAME CHAR(10),
PROC_NAME VARCHAR2(100),
REG VARCHAR2(1000) NOT null,
PRIMARY KEY (ID)
);
CREATE INDEX PROC_NAME_INDEX ON DEVELOP.TEST240104(PROC_NAME);
CREATE INDEX INFO_NAME_INDEX ON DEVELOP.TEST240104(INFO_NAME);
ALTER TABLE DEVELOP.TEST240104 ADD CONSTRAINT PROC_NAME_CONSTRAINT UNIQUE (PROC_NAME);