Employee of The Month: How to be become one?

Employee of The Month   How to be named employee of the month? Get to work on time. Being an early bird is better though. Of course, there are more things that we need to do but it’s the first step to become one right?


Draw.io Review : Free Online Diagram Tool

The most widely known and commonly used tool for creating diagrams with ease probably is Microsoft Visio. But it’s quite pricey for personal use. There are a lot of free online diagram tools as an alternative for those who need an immediate way to begin creating diagrams. I already used Draw.io in order to creating a nice…


Display List of All Views on Oracle Database

Oracle Views These are queries that you can used to display the views on Oracle. ALL_VIEWS describes the views accessible by logged user. select * from all_views DBS_VIEWS describes all views however you need DBA priviledges for this query. select *  from dba_views USER_VIEWS describes the views owned by logged user. select *  from user_views Also you…


Encrypt Text to MD5 on Oracle Database

Encrypt MD5 First of all, you need to have access on DBMS_OBFUSCATION_TOOLKIT since it enables an application to encrypt data using either the Data Encryption Standard (DES) or the Triple DES algorithms. Here is the example how to encrypt text to MD5 on Oracle Database. First create the function called ENCRYPTMD5 and execute it later in order to…


Calculate Duration from Date on Oracle Database

Calculate Duration Here is the example query to calculate duration in hour : select (to_date(‘2016-12-06 22:00’, ‘YYYY-MM-DD hh24:mi’) – to_date(‘2016-12-06 19:30’, ‘YYYY-MM-DD hh24:mi’)) * 24 duration_hours        from dual; Result in minute : select (to_date(‘2016-12-06 22:00’, ‘YYYY-MM-DD hh24:mi’) – to_date(‘2016-12-06 19:30’, ‘YYYY-MM-DD hh24:mi’)) * 24 * 60 duration_minutes        from dual; Result in second :…


ALL_SOURCE: Show the Source Stored Procedure/ Function, Trigger, etc on Oracle Database

Oracle all_source These are the query to display the source for an Oracle stored procedure/ function, trigger, etc : all_source describes the text source of the stored objects accessible to the current user. select * from all_source; user_source describes the text source of the stored objects owned by the current user. select * from user_source; Here is the…