PROCEDURE : FUNCTION : Hasil :
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
Read More
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
ISO Standard : look a different with Reference : http://ss64.com/ora/syntax-fmt.html
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
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
Read More
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 #
Read More
Comments