create table TESTUSER.TESTTABLE100W
(
id INTEGER PRIMARY KEY,
name VARCHAR2(100),
sal NUMBER(8,2),
tel NUMBER(13),
age INTEGER,
a VARCHAR2(100),
b VARCHAR2(100),
c VARCHAR2(100),
d VARCHAR2(100),
e VARCHAR2(100)
);
create table TESTUSER.TESTTABLE100W_BF
(
id INTEGER PRIMARY KEY,
name VARCHAR2(100),
sal NUMBER(8,2),
tel NUMBER(13),
age INTEGER,
a VARCHAR2(100),
b VARCHAR2(100),
c VARCHAR2(100),
d VARCHAR2(100),
e VARCHAR2(100)
);
BEGIN
FORI IN 1..100000 LOOP
INSERT INTO TESTUSER.TESTTABLE100W VALUES(I,DBMS_RANDOM.STRING('X',10),DBMS_RANDOM.VALUE(1000,50000),('13'||DBMS_RANDOM.VALUE(0,9))*1000000000,DBMS_RANDOM.VALUE(20,60),DBMS_RANDOM.STRING('X',15),DBMS_RANDOM.STRING('X',20),DBMS_RANDOM.STRING('X',25),DBMS_RANDOM.STRING('X',30),DBMS_RANDOM.STRING('X',35));
ENDLOOP;
COMMIT;
END;
INSERT INTO TESTUSER.TESTTABLE100W values(1000001, 'h10', '2000','010','10','a0','ba','ca','da','ee')
INSERT INTO TESTUSER.TESTTABLE100W values(1000002, 'h10', '2000','010','10','a1','ba','ca','da','ee')
INSERT INTO TESTUSER.TESTTABLE100W_BF SELECT *FROM TESTUSER.TESTTABLE100W;
UPDATE TESTUSER.TESTTABLE100W SETA=testuser.encryt_des3(A);
SELECT * FROM TESTUSER.TESTTABLE100W WHERE ID= 135;
SELECT * FROM TESTUSER.TESTTABLE100W WHEREtestuser.decrypt_des3(A)='A0';
