Oracle, Web, Script, SQLserver, Tips & Trick

April 5, 2016

How to add license vnc server linux

Filed under: linux — sikathabis @ 8:22 am
Tags: , ,

Connect linux using putty or others application using root user

example:

vnclicense -add ABCD1-EFGH2-IJKL3-MNOP4-QRST5

reference: https://www.realvnc.com/products/vnc/documentation/5.0/installing-removing/redhat

Advertisements

February 17, 2016

How to create Script to generate a table structure in oracle

Filed under: oracle — sikathabis @ 9:13 am
Tags: ,

–Script

select  tc.table_name "TABLE",
        column_id ID,
        rtrim(column_name) COLUMN_NAME, 
        rtrim(data_type) ||
        rtrim(decode(data_type,'DATE',null,'LONG',null,
               'NUMBER',decode(to_char(data_precision),null,null,'('),
               '(')) ||
        rtrim(decode(data_type,
               'DATE',null,
               'CHAR',data_length,
               'VARCHAR2',data_length,
               'NUMBER',decode(to_char(data_precision),null,null,
                 to_char(data_precision) || ',' || to_char(data_scale)),
               'LONG',null,
               ''))||
        rtrim(decode(data_type,'DATE',null,'LONG',null,
               'NUMBER',decode(to_char(data_precision),null,null,')'),
               ')')) || ' ' || ' ' DATA_TYPE,
        rtrim(decode(nullable,'N','NOT NULL',null)) OTHERS
from    dba_tab_columns tc,
        dba_objects o
where   o.owner = tc.owner
and     o.object_name = tc.table_name
and     o.object_type = 'TABLE' 
and     o.owner = 'USERDATABASE';

–Example result

TABLE    ID   COLUMN_NAME   DATA_TYPE     OTHERS
ACUAN    1    ID            NUMBER        NOT NULL
ACUAN    2    MIN_RATING    NUMBER(22,5)  NOT NULL
ACUAN    3    MAX_RATING    NUMBER(22,5)  NOT NULL
ACUAN    4    RISK_RATING   CHAR(10)      NOT NULL
KD_TRAN  1    ID            VARCHAR2(20)  NOT NULL
KD_TRAN  2    KD_TRAN       VARCHAR2(4)   NOT NULL

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

August 22, 2015

Comparison external hard drive cable

Filed under: hardware — sikathabis @ 12:17 pm
Tags: , , ,

I have two hard drives, have same specification, but the cable looks like same but when I see closely, were different. And when I copied data, the speed of copying is totally different. Can you guess, a cable which has a faster speed ?

20150802203606 20150802203613

 

This reference for detailed comparation cable types: http://knowledge.seagate.com/articles/en_US/FAQ/205479en?popup=true

August 10, 2015

How to hide password login to oracle in CMD

Filed under: linux,oracle,windows — sikathabis @ 10:14 am
Tags: , ,

I have application for backup database, in the application I’ve created, can generate user password, without other user know what the password is. Other user use that application which can see the content of .bat file where my application whom creating that file, the trouble is, other user can see password from login “user/password@tnsnames” . There are many solution to hide the password from Mbah Google, but there’s one reference very usefull

http://stackoverflow.com/questions/17807188/how-to-authenticate-oracle-login-using-encrypted-password (first comment)

example: echo generatepassword | exp username@tnsnames file=backup.dmp owner=scott

“Echo generatepassword |” is created on the application, and “exp username@tnsnames file=backup.dmp owner=scott” is .bat file which can other user see or using it.

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/

March 16, 2015

Route | Routing

Filed under: network — sikathabis @ 4:19 am
Tags: ,

Jika posisi network/jaringan di lingkungan anda terdapat LAN dan Wireless, kemudian bermasalah terhadap koneksi internet jika kedua jaringan terkoneksi secara bersamaan, maka solusinya adalah

1. Cek dahulu posisi route, contoh pada Gambar 1. Network destination 0.0.0.0 ada di dua posisi, yaitu LAN dan Wireless (10.10.4.254) dimana LAN (192.168.20.65) posisinya prioritas.

Route Print kembali

Gambar 1. Route Print

2. Agar koneksi internet berjalan dan LAN juga bisa terkoneksi, maka yang harus dilakukan adalah menghapus route 0.0.0.0 pada LAN, kemudian melakukan penambahan routing utk jaringan lokal ke gatway-nya. (Gambar 2)

Route Delete dan add

Gambar 2. Route Delete dan add

3. Cek kembali route yang telah disetting, pastikan untuk destination 0.0.0.0 hanya di posisi Wireless (Gambar 3)

Route Print

Gambar 3. Route Print kembali

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…)

« Previous PageNext Page »

Create a free website or blog at WordPress.com.

Learning is not a spectator sport

Connor McDonald's Oracle blog

Teknologi Pendidikan

Just another WordPress.com weblog

KATAKAMI

Jurnalisme Yang Dapat Dipercaya

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Bodoh Yang Tak Kunjung Pandai

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server

arihdyacaesar

"A distance is getting far if your heart is impatient" -ean-

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

DRK™

This site is about Latest NEWS, Articles, Videos, Books, Course, Presentations, Tips & Tricks related to I.T Pro's

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