Hi! I need to change the encryption of user passwords (well... hashes) from old package to new package.
Sample table
CREATE TABLE USERS
(
USERS_ID NUMBER NOT NULL,
USERS_FIRST_NAME VARCHAR2(20 BYTE) NOT NULL,
USERS_LAST_NAME VARCHAR2(20 BYTE) NOT NULL,
USERS_DISPLAY_NAME VARCHAR2(50 BYTE),
USERS_PASSWORD VARCHAR2(255 BYTE) NOT NULL,
USERS_NAME VARCHAR2(30 BYTE) NOT NULL,
USERS_EMAIL VARCHAR2(48 BYTE),
USERS_PHONE VARCHAR2(40 BYTE)
)

So, I need to decrypt existing passwords using "legacy" package (LEGACY_CRYPT.DECRYPT()) and encrypt using new package NEW_CRYPT.ENCRYPT().

Can it be done without Cursors?

Many thanks in advance,

So, I need to decrypt existing passwords using "legacy" package (LEGACY_CRYPT.DECRYPT()) and encrypt using new package NEW_CRYPT.ENCRYPT().

Can it be done without Cursors?

update USERS set USERS_PASSWORD = NEW_CRYPT.ENCRYPT(LEGACY_CRYPT.DECRYPT(USERS_PASSWORD));