Create a "is_encrypted" function which returns if the string is encrypted, then use a case statement to return the decrypted value either via the decrypt function or just straight out of the table select case when is_encrypted(secret) = 'Y' then decrypt(secret) else secret end as ecrypted_secret from emp Or as suggested in question comments, just change the decrypt function so if its passed a non encrypted string, it just returns the string it was passed.
Create a "is_encrypted" function which returns if the string is encrypted, then use a case statement to return the decrypted value either via the decrypt function or just straight out of the table. Select case when is_encrypted(secret) = 'Y' then decrypt(secret) else secret end as ecrypted_secret from emp Or as suggested in question comments, just change the decrypt function so if its passed a non encrypted string, it just returns the string it was passed.
Essentially what I want to do is modify a refcursor before it is returned. However, I don't think that's possible. My first thought was to build up an associative array of cursor%ROWTYPE.
I can do that. However, I can't find a way to return an associative array as a refcursor. Any thoughts on a strategy?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.