Create New Table

CREATE TABLE misc_type_map (
mtm_id NUMBER(5) NOT NULL,
mt_id NUMBER(10) NOT NULL,
mtm_table_nam VARCHAR2(50) NOT NULL,
mtm_field_nam VARCHAR2(50) NOT NULL,
mtm_sts NUMBER(1) NOT NULL,
created_by NUMBER(10) NOT NULL,
creation_date DATE NOT NULL,
last_modified_by NUMBER(10) NOT NULL,
last_modified_date DATE NOT NULL,
CONSTRAINT pk_mtm_id_1 PRIMARY KEY(mtm_id)
);
CREATE SEQUENCE mtm_id_seq INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;