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

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