Nurjayanti changed their profile picture 7 years, 2 months ago
aprianimusfiroh and
Nurjayanti's profile was updated 7 years, 2 months ago
Nurjayanti wrote a new post on the site aLTER 7 years, 2 months ago
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 […]
Nurjayanti wrote a new post on the site aLTER 7 years, 4 months ago
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 […]
Nurjayanti wrote a new post on the site aLTER 7 years, 4 months ago
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 i […]
Nurjayanti wrote a new post on the site aLTER 7 years, 4 months ago
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 […]
Nurjayanti wrote a new post on the site aLTER 7 years, 4 months ago
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 […]