Title
Date
Author
Comments
April 5th, 2017
Gia
Comments Off on Fungsi & Prosedur Terbilang di MySQL

PROCEDURE : FUNCTION : Hasil :

September 5th, 2013
Gia
Comments Off on Generate CSV from MySQL

Query to generate CSV file : Error when user don’t have privilege to create file : Add grant to create file (execute using root user or user with grant option) : ** GRANT FILE only works with ON *.* If you want delete, remove or revoke GRANT file :

October 10th, 2012
Gia
Comments Off on Get last data (last created) in Oracle using “over partition”

Source data : * I want to get rows in yellow highlight. Query : Result Query : Result : Reference : http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions137.htm

March 13th, 2012
Gia
Comments Off on Get Week Number according to ISO Standard

ISO Standard : look a different with Reference : http://ss64.com/ora/syntax-fmt.html

October 28th, 2010
Gia
Comments Off on oci8 on openSUSE 11

Download oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip Download oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip unzip oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip unzip oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip mv instantclient_11_2/ /usr/local/instantclient11 cd /usr/local/instantclient11/ ln -s libclntsh.so.11.1 libclntsh.so

February 6th, 2010
Gia
Comments Off on OCI8, Oracle Instantclient 11 & CentOS 5.4 64bit

Langsung deh : Download oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip Download oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip unzip oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip unzip oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip mv instantclient_11_2/ /usr/local/instantclient11 cd /usr/local/instantclient11/ ln -s libclntsh.so.11.1 libclntsh.so yum install php-pear yum install php-devel pecl install oci8 Jawab pertanyaan “Please provide the path to the ORACLE_HOME directory. Use ‘instantclient,/path/to/instant/client/lib’ if you’re compiling with Oracle Instant Client [autodetect]”  dengan instantclient,/usr/local/instantclient11 vi /etc/php.d/oci8.ini, tambahkan baris […]

January 7th, 2009
Gia
Comments Off on error starting MySQL di Slackware 12.2

Habis error httpd nemu lagi error di MySQL bawaannya Slackware 12.2 :( pas lagi booting service MySQL langsung stop dengan sendirinya. Selidik punya selidik tanya-tanya ke mbah Google cuma jalanin beberapa perintah dibawah, service MySQL berjalan dengan lancar :D # mysql_install_db # chown -R mysql.mysql /var/lib/mysql Kemudian coba jalankan perintah berikut untuk mengecek apakah service […]