Re: how to do an update of the already encrypted data
From: Sanae <aithssaine.sanae_at_gmail.com>
Date: Tue, 14 Jul 2015 10:45:56 -0700 (PDT)
Message-ID: <5cfb507d-e776-498c-b436-facca332c933_at_googlegroups.com>
Thank's Michel for your replay
exactly I want to do it manually
if I am using the trigger before insert and update i can do a simple update update emp set prenom='newName';
but i need to do this
update emp set prenom=prenom||'Something';
Date: Tue, 14 Jul 2015 10:45:56 -0700 (PDT)
Message-ID: <5cfb507d-e776-498c-b436-facca332c933_at_googlegroups.com>
Thank's Michel for your replay
exactly I want to do it manually
if I am using the trigger before insert and update i can do a simple update update emp set prenom='newName';
but i need to do this
update emp set prenom=prenom||'Something';
knowing that all columns are encrypted now
so i need first to decrypte the columns ,then update finally encrypte using the old key stored on image;
need anwser as soon as possible
thank you in advance :)
Received on Tue Jul 14 2015 - 19:45:56 CEST