DELETE FROM BLEDY;
DROP TABLE BLEDY;
CREATE TABLE
BLEDY
(
BLEk_1_ID NUMBER(4) NOT NULL,
BLE_KOMUNIKAT VARCHAR2(50) ,
BLE_RODZAJBLEDU VARCHAR2(50)
);
ALTER TABLE BLEDY
ADD CONSTRAINT CSR_PK_BLEDY PRIMARY KEY (BLEk_1_ID);

DROP SEQUENCE SEQ_BLEDY;
CREATE SEQUENCE SEQ_BLEDY INCREMENT BY 1 START WITH 1
maxvalue 9999999999 minvalue 1;


CREATE OR REPLACE TRIGGER T_BI_BLEDY
BEFORE INSERT ON BLEDY
FOR each ROW
BEGIN
IF :NEW.BLEk_1_ID IS NULL THEN
SELECT SEQ_BLEDY.NEXTVAL INTO :NEW.k_1_ID FROM dual;
END IF;
END;
/