Fungsi & Prosedur Terbilang di MySQL
PROCEDURE : FUNCTION : Hasil :
Category: Database
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)… Read more »
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
Get Week Number according to ISO Standard
ISO Standard : look a different with Reference : http://ss64.com/ora/syntax-fmt.html
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
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… Read more »
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… Read more »