CREATE TABLE content ( id NUMBER(19) NOT NULL, content_id VARCHAR2(255) UNIQUE NOT NULL, content_message VARCHAR2(255), is_delete NUMBER(1) DEFAULT 0, created_date TIMESTAMP DEFAULT SYSTIMESTAMP, updated_date TIMESTAMP DEFAULT SYSTIMESTAMP, CONSTRAINT content PRIMARY KEY (id) ); DROP TABLE content; select * from content; CREATE SEQUENCE content_id_seq START WITH 1; DROP SEQUENCE id_seq; DROP SEQUENCE content_id_seq; CREATE SEQUENCE id_seq START WITH 1; CREATE SEQUENCE content_id_seq START WITH 1 INCREMENT BY 1; CREATE OR REPLACE TRIGGER id_trigger BEFORE INSERT ON content FOR EACH ROW BEGIN	:NEW.id := id_seq.NEXTVAL; END; CREATE OR REPLACE TRIGGER content_id_trigger BEFORE INSERT ON content FOR EACH ROW BEGIN	:NEW.content_id := 'content-' || content_id_seq.NEXTVAL; -- IF :NEW.content_id = 'content-' THEN -- :NEW.content_id := :NEW.content_id || content_seq.NEXTVAL; -- ELSE -- RAISE_APPLICATION_ERROR(-20001, 'Unknown content type: ' || :NEW.content_id); -- END IF; END; truncate content; select * from content; INSERT INTO content(content_id, content_message, is_delete) VALUES ('content-', 'Thank you for your order! Your order #{order_number} has been confirmed and will be shipped on {shipping_date}.', 0);