db.sql

DROP TABLE jokes;

CREATE TABLE jokes (
    id      NUMBER        GENERATED BY DEFAULT ON NULL AS IDENTITY,
    joke   VARCHAR2(8168) NOT NULL,
    PRIMARY KEY (id)
);

select * from jokes;


-- select count(*) from jokes;

-- commit;

CREATE TABLE "JOKES"."JOKES" 
   (	"ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE , 
	"JOKE" VARCHAR2(8168 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "JOKES"."JOKES" MODIFY ("ID" NOT NULL ENABLE);

ALTER TABLE "JOKES"."JOKES" MODIFY ("JOKE" NOT NULL ENABLE);

ALTER TABLE "JOKES"."JOKES" ADD PRIMARY KEY ("ID")
  USING INDEX  ENABLE;