Oracle, Web, Script, SQLserver, Tips & Trick

February 11, 2015

License Using picture dreamstime on wordpress themes

Filed under: web — sikathabis @ 1:28 am
Tags: , , , ,

QUESTION:

I’m using one of image on dreamstime, for using it on my wordpress’s themes, Is it allowed ?

ANSWER:

Yes you can use any of our commercial images under the standard RF license. More about our standard license you can read below:
http://www.dreamstime.com/terms#royaltyfree

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.

December 8, 2014

Function GET_FILENAME and GET_PATHNAME

Filed under: dev6i,oracle — sikathabis @ 8:47 am
Tags: , ,

FUNCTION GET_FILENAME(PKALIMAT VARCHAR2) RETURN VARCHAR2 IS
kata varchar2(100):=null;
KALIMAT VARCHAR2(1000):=PKALIMAT;
c number:=0;
KAR CHAR(1):=’/';
BEGIN

IF INSTR(PKALIMAT,KAR)=0 THEN
KAR:=’\';
END IF;

FOR i in 1..length(KALIMAT)
LOOP
if substr(kalimat,i,1)=KAR then
c:=c+1;
end if;
END LOOP;

FOR i in 1..c
LOOP
kata:= substr(KALIMAT,1,instr(KALIMAT,KAR)-1);
KALIMAT := replace(kalimat,kata||KAR,”);
END LOOP;

RETURN KALIMAT;

END;

——————————————————————— (more…)

December 5, 2014

How to Make cursor default or busy (oracle dev 6i)

Filed under: dev6i,oracle — sikathabis @ 3:29 am
Tags: ,

SET_APPLICATION_PROPERTY(CURSOR_STYLE,’BUSY’);

Detail Information about Cursor_Style

Detail Information about Cursor_Style

SET_APPLICATION_PROPERTY(CURSOR_STYLE,’DEFAULT’);

November 19, 2014

How to create user another sa (sysadmin) using CMD on sql server 2005

Filed under: dos,sqlserver — sikathabis @ 4:40 am
Tags: ,

I’m having trouble with sa user, its broken because I drop default database. And then the solution is create another user sysadmin which has same privilege with sa user. I’m using SQL Server 2005, other version can be different statement, please read Microsoft SQL Server online instruction for other version.

Firstable login SQL to instance, for example Taufan-PC (instance)
Create User

Create login dan Grant user to sysadmin, for example super (user)
Grant User to sysadmin

 

reference:

October 22, 2014

How to show excel delimited text value number as a string

Filed under: excel — sikathabis @ 8:04 am
Tags: , ,

For example I have two character data (No Nasabah and Kode Sektor Ekonomi)

No Nasabah <tab> Kode Sektor Ekonomi
012 <tab> 091420

Creating delimited text with tab(9) separated result 12    91420, but if you want to show all number include zero in front of data, then you should add =” before data and add ” after data. For example:

No Nasabah <tab> Kode Sektor Ekonomi
=”012 <tab> =”091420

Creating delimited text with tab(9) separated result 012    091420

Snapshot

example before and after

example before and after

 

October 9, 2014

How to change tablespace on indexes using script

Filed under: oracle — sikathabis @ 8:29 am
Tags: , ,

In this case:

  • I have tablespaces VBS_MASTER, VBS_MASTER_IDX, VBS_HIST, VBS_HIST_IDX
  • I want to move all indexes on user DBADMIN tablespace _IDX to without _IDX  (exp: VBS_HIST_IDX –> VBS_HIST)

Script running on user DBADMIN:

spool movetablespace.sql
 select 'ALTER INDEX ' ||INDEX_NAME||' REBUILD TABLESPACE '|| replace(TABLESPACE_NAME,'_IDX','')||';' as "--TITLE"
 from dba_indexes
 where owner='DBADMIN' and tablespace_name like '%IDX';
 spool off
 @movetablespace.sql

September 29, 2014

Cara upgrade Oracle Database 10g 10.2.0.1 menjadi 10.2.0.5

Filed under: oracle,oracle:10g — sikathabis @ 12:01 am
Tags: , ,

Secara garis besar dari dokumen readme.htm

  1. Matikan lsnrctl, matikan enterprise manager console, matikan database
  2. Installasi dari patch yg didownload (setup.exe), kemudian oracle homenya pilih ke lokasi oracle yg mau di patch
  3. Untuk upgrade database terdiri dari Interaktif mode dan manual mode:
    • Untuk interaktif Jalankan dbua pada CMD ~ README.htm#CJAGAIBC (jika ini tidak berhasil lakukan cara dibawah ini
    • Untuk manual (liat di readme.htm utk yg manual) ~ README.htm#CJGGABGI
      1. 10.5.2.1 Run the pre-ugrade information tool ini berfungsi utk pengecekan awal
      2. 10.5.2.2 Upgrading a release 10.2 Database terdiri dari nomor 1 s/d 15, tapi tidak semua dijalankan.  Jalankan nomor 1, 4, 5, 7, 10, 11 dan 15 (jika di perlukan)

Untuk detailnya silahkan baca dari readme.htm atau extract patch 10.2.0.5, ada file readme.htm

Attachment: Readme.htm, hilangkan extension .jpg

September 22, 2014

How to compress and extract on unix/linux using tar (gzip)

Filed under: linux,server,server:ibm — sikathabis @ 7:54 pm
Tags: , , ,

COMPRESS

tar -zcvf filename.tar.gz fileordirectory

EXTRACT to current directory

tar -zxvf filename.tar.gz

September 9, 2014

Tutorial Penggunaan Crontab Scheduler di Ubuntu

Filed under: Uncategorized — sikathabis @ 4:00 am

sikathabis:

Contoh Crontab

Originally posted on 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 391 more words

Next Page »

The Rubric Theme. Blog at WordPress.com.

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server

neinframe

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

Keluarga Andrivito

-- Andrivito's Journal --

Dinesh Ram Kali.

This Blog is about latest News & update on software life-cycle. Free eBooks to download. Videos for few tips & tricks related to IT Industry.

Gaurav Saxena

|| तत् त्वम् असि ||

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

fluoresensi

Keinginan itu pasti terwujud, entah 1 tahun, 2 tahun hingga puluhan tahun kemudian. Bersabarlah #cumanmasalahwaktu

Kumpulan gambar favoritku

Kumpulan gambar favoritku

Rumahku Surgaku

Just another way to share

juliansherman

Just another WordPress.com site

waiting room

: dari senyap ruang tunggu, tempat aku menemukan-Mu

Follow

Get every new post delivered to your Inbox.

Join 40 other followers