Oracle, Web, Script, SQLserver, Tips & Trick

July 6, 2018

PL/SQL: Sleep without using DBMS_LOCK

Filed under: Uncategorized — sikathabis @ 11:50 am

Oracle Deli

If you want to wait in your PL/SQL program (“sleep”) you may want to use the procedure “SLEEP” from the package “DBMS_LOCK“. While this function does exactly what you want, your DBA may not grant you access to this package, because it contains some other mighty and dangerous procedures.

But there is help! Here are some valid alternatives:

Option 1: APEX_UTIL.sleep

If APEX is installed you can use the procedure “PAUSE” from the publicly available package APEX_UTIL.

Example – “Wait 5 seconds”:

    DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    DBMS_OUTPUT.PUT_LINE('End   ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));

Option 2: java.lang.Thread.sleep

An other option is the use of the method “sleep” from the Java class “Thread”, which you can easily use through providing a simple PL/SQL wrapper procedure:


View original post 48 more words


October 7, 2017

Auto-backups of PLSQL source

Filed under: Uncategorized — sikathabis @ 4:11 pm

Auto backups of plsql source

October 3, 2016

Windows 10 start menu doesn’t appear | start menu won’t show | start menu tidak muncul

Filed under: Uncategorized — sikathabis @ 9:32 am
Tags: , , ,


Windows 10 start menu doesn’t appear

Windows 10 start menu won’t show

Windows 10 start menu tidak muncul


  • Buka Regedit.exe
  • Klik kanan pada HKEY_Users / HKEY_CLASSES_ROOT / HKEY_LOCAL_MACHINE dan click permissions (jalankan di masing-masing HKEY)
  • Pastikan ALL APPLICATION PACKAGES allow read, jika ALL APPLICATION PACKAGES belum ada, maka tambahkan dengan cara:
    1. Click Add
    2. Click Advanced
    3. Click Find Now
    5. Click Ok, Click Ok
    6. Lalu Check list Read pada ALL APPLICATION PACKAGES
    7. Click Ok



December 13, 2015

Gelar Akademis

Filed under: Uncategorized — sikathabis @ 5:54 am

Gelar Akademis

Ulfiarahmi's Weblog

Gelar Vokasi
A.P            : Ahli Pratama
A.Ma        : Ahli Muda
A.Md        : Ahli Madya
A                : Profesional Ahli
A.Ma.Pd  : Ahli Muda Kependidikan
A.Md.Per: Ahli Madya Keperawatan

View original post 1,323 more words

May 12, 2015

Troubleshoot Jabref with germany font

Filed under: Uncategorized — sikathabis @ 5:34 am

If you have trouble with your jabref (bibliography or daftar pustaka) there’s an Author name containt ö and the result is ö. To solve the problem change ö with \”{o} in the BibTeX source


December 31, 2014

2014 in review

Filed under: Uncategorized — sikathabis @ 12:10 am

The stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 9,100 times in 2014. If it were a concert at Sydney Opera House, it would take about 3 sold-out performances for that many people to see it.

Click here to see the complete report.

September 9, 2014

Tutorial Penggunaan Crontab Scheduler di Ubuntu

Filed under: Uncategorized — sikathabis @ 4:00 am

Contoh Crontab

cd /home/gosigitgo/

Apa itu cron / crontab ? Crontab adalah aplikasi daemon (berjalan dibalik layar) yang digunakan untuk menjalankan tugas yang dijadwalkan pada suatu waktu di sistem operasi linux. Setiap user di sistem yang memiliki file crontab, mengijinkan file tersebut untuk melakukan suatu aksi yang telah dispesifikasikan sesuai waktu yang telah ditentukan. Crontab biasa digunakan untuk membuat backup secara otomatis, sinkronisasi files, dll.

1. Install crontab

Buat yang belum diinstall crontab-nya, cara install nya adalah :

sudo apt-get install cron

2. Melihat aktifitas crontab
Untuk melihat schedule yang sedang berjalan di sistem Anda :

sudo crontab -l

3. Mengedit cron jobs

sudo crontab -e

editor default dari cron adalah vi atau pico
4. Format penulisan cron
Format penulisan crontab ditulis dengan format seperti ini :

* * * * * /home/sigit/

Penjelasan :
5 bintang (*) diatas merepresentasikan bagian2 format tanggal yang berbeda, urutannya sebagai berikut :
1. (* pertama) : menit…

View original post 391 more words

December 25, 2013

How to open or extract or convert .smm file (Using SBU Extractor)

Filed under: Uncategorized — sikathabis @ 5:15 pm
Tags: ,
Just choose the .sbu file and select which data you want! Calender and To Do or Contacts or both.
Do not extract as a single file (choose No) or you will just get one big .vcf file The folder/s will be created automatically and you`ll find there many .vcf files for your phone



Alternative Download link


June 7, 2013

Optimizing code for the European Space Agency

Filed under: Uncategorized — sikathabis @ 11:31 pm


The StrayLight algorithm performs digital processing on data sent from satellites, clearing up unintended lighting effects recorded inside them.

The prototype provided by ESA personnel, was implemented in the IDL programming language. IDL is a near-perfect match for its intended audience, offering an easy way for scientists and engineers to analyze and process data (scalars, vectors, matrices, etc, as well as ready-made library functions for FFTs, interpolations, convolutions, …)

Moreover, the associated REPL [2] execution environment compiles the IDL code on the fly (in a manner very similar to that of a JIT engine [3]). In collaboration with the highly optimized implementations of the underlying primitives, the end result offered by IDL is an excellent balance between code complexity and run-time speed.

There is, however, room for improvement in that final regard – speed.

The following sections demonstrate how we increased the overall execution speed of the complete StrayLight algorithm (including the PSF computation) in our development machine [4] by a factor of close to 8x, through porting of the IDL code to C++/CUDA. In fact, since the calculation of the PSF data is not frame-dependent [5], the parts of the computation that have to be performed per frame are executing 35 times faster, enabling real-time processing.

Nara Sumber : IMW

August 5, 2011

Graph Visualization Software

Filed under: Uncategorized — sikathabis @ 2:23 am




Next Page »

Create a free website or blog at



Learning is not a spectator sport

Connor McDonald on SQL and the Oracle Database

Teknologi Pendidikan

Just another weblog


Jurnalisme Yang Dapat Dipercaya

Tonk Kosonk Baonk Bunyinya

Penampungan Serapah Tanpa Sumpah

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Desa Yang Mencintai Desa dan Kebudayaannya

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server


"Tuhan tidak menuntut kita untuk menang. Tuhan hanya meminta kita untuk berjuang tanpa henti.” -ean-


Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa


Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku


Ceritanya saya, Pikirannya saya, Hatinya saya


sikathabis semua informasi disini

Don Charisma

because anything is possible with Charisma