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”:

SET SERVEROUTPUT ON ;
BEGIN
    DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    APEX_UTIL.PAUSE(5);
    DBMS_OUTPUT.PUT_LINE('End   ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
END;
/

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:

CREATE OR REPLACE PROCEDURE SLEEP

View original post 48 more words

Advertisements

October 7, 2017

Auto-backups of PLSQL source

Filed under: Uncategorized — sikathabis @ 4:11 pm

Auto backups of plsql source

Learning is not a spectator sport

I saw this on an ideas forum today

image

and whilst most people would take care of this with a source code control system, its also true that people might do several compilations / tests with their PLSQL source before checking it in officially to their source repository.

So the idea has some merit… and maybe we can roll our own without too much fuss. I make no claims that this is a ‘complete’ solution, but it should get you going Smile

 SQL> set timing off SQL> drop trigger plsql_trigger; Trigger dropped. SQL> SQL> drop table plsql_params purge; Table dropped. SQL> drop table plsql_history cascade constraints purge; Table dropped. SQL> drop table plsql_history_source cascade constraints purge; Table dropped. SQL> drop table plsql_log cascade constraints purge; Table dropped. SQL> SQL> SQL> create table plsql_params 2 as select 3 versions_kept from dual; Table created. SQL> SQL> create table plsql_history ( 2 TSTAMP TIMESTAMP 3…

View original post 604 more words

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: , , ,

Permasalahan:

Windows 10 start menu doesn’t appear

Windows 10 start menu won’t show

Windows 10 start menu tidak muncul

Solusi:

  • 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
    4. Pilih ALL APPLICATION PACKAGES
    5. Click Ok, Click Ok
    6. Lalu Check list Read pada ALL APPLICATION PACKAGES
    7. Click Ok

Referensi: https://support.microsoft.com/en-us/kb/2798317

 

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

reference: https://forums.zotero.org/discussion/3567/exporting-of-items-with-german-umlaut-ae-oe-ue/

December 31, 2014

2014 in review

Filed under: Uncategorized — sikathabis @ 12:10 am

The WordPress.com 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/script.sh

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
example

Reference:

  1. http://www.askmefast.com/How_to_openeditconvert_samsung_smm_files_for_memos_without_kies-qna4923682.html
  2. https://www.lord-luncher.de/

Alternative Download link

 

June 7, 2013

Optimizing code for the European Space Agency

Filed under: Uncategorized — sikathabis @ 11:31 pm
Tags:

links: http://users.softlab.ntua.gr/~ttsiod/straylight.html

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
Tags:

 

 

 

 

 

 

http://www.graphviz.org

Next Page »

Blog at WordPress.com.

Pureblood

DONT WANNA BE NUMBER ONE

Learning is not a spectator sport

Connor McDonald on SQL and the Oracle Database

Teknologi Pendidikan

Just another WordPress.com weblog

KATAKAMI

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

arihdyacaesar

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

neinframe

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

TuanSUFI

Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku

Angkasa13

Ceritanya saya, Pikirannya saya, Hatinya saya

sikathabis

sikathabis semua informasi disini

Don Charisma

because anything is possible with Charisma