Create Table

• Create table without define the primary key at the beginning

CREATE TABLE myschema.kategori
(
kategoriid NUMBER(5),
katoriname VARCHAR2(30),
description VARCHAR2(50)
)
TABLESPACE etiket_tbl;

• Adding the primary constraint into table

ALTER TABLE myschema.kategori
ADD CONSTRAINT pkkategori
PRIMARY KEY (kategoriid)
USING INDEX
TABLESPACE etiket_idx;