CREATE SEQUENCE seq_wydawnictwo START WITH 10;
CREATE OR REPLACE PROCEDURE zad2
AS
x1 VARCHAR2(30);
x2 VARCHAR2(30);

BEGIN
DBMS_RANDOM.INITIALIZE(100);
DBMS_RANDOM.SEED(TO_CHAR(SYSDATE,'SSYYYYMIMMHH24DD'));
x1:=DBMS_RANDOM.STRING('U',30);
x2:=DBMS_RANDOM.STRING('L',30);
INSERT INTO wydawnictwo VALUES(seq_ksiazka.nextval,x1,x2);
DBMS_RANDOM.TERMINATE;
END;
/
EXECUTE zad2;
SELECT * FROM wydawnictwo;