Data encryption and decryption using PL/SQL
Data encryption is the one of the key feature for security. It can be used for several purposes. I used DBMS_CRYPTO package for this. DBMS_CRYPTO.ENCRYPT function requires the […]
More DetailsCategory: DBA
ORA-12034 materialized view log on younger than last refresh
Hi all, if you encounter ORA-12034 error. It means, a complete refresh is required before the next fast refresh. So, I run the code below in order to […]
More DetailsRegular Expression
You can use the following character classes for your regex pattern. Character Class Description [:alnum:] Alphanumeric characters [:alpha:] Alphabetic characters [:blank:] Blank Space Characters [:cntrl:] Control characters (nonprinting) […]
More DetailsHow to update user’s password with the same password
If you don’t know the user’s password that had been saved in TOAD or SQL DEVELOPER and will expire soon. You can update as it is. In Oracle […]
More DetailsJOB_QUEUE_PROCESSES parameter
In our company we came across duplicative jobs that have been executed by the system. After an investigation, we find out that, these jobs were run from our […]
More Details