Procedure
-
Create an Oracle table called PERSON with four fields:
ID, NAME,
AGE and COUNTRY, as
follows.
CREATE TABLE TABLE_PERSON ( ID NUMBER(4) NOT NULL , NAME VARCHAR2(25) , AGE NUMBER(5) , COUNTRY VARCHAR2(20) , CONSTRAINT PERSON_PK PRIMARY KEY ( ID ) ENABLE ); -
Create an Oracle sequence called sequence_demo.
CREATE SEQUENCE SEQUENCE_DEMO INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE;