Latest Articles
Install Oracle JDK 8 on Raspberry Pi
#oracle #javaIn this post, I’ll show you how to download and install Oracle JDK 8 on a Raspberry Pi. Visit Oracle download website and click the download button for Java Platform (JDK) 8. Then accept the licen... Read more
20 Oct 2016 - less than 1 minute readLast rowcount in MySQL
#mysqlSuppose you want to count the number of lines returned by the last SQL statement issued. For select statements you can use the FOUND_ROWS construct: SELECT SQL_CALC_FOUND_ROWS something FROM your_... Read more
20 Sep 2016 - less than 1 minute readImplement an MD5sum function in Oracle
#oracleA few days ago, I was looking for a way to get an MD5sum function to work directly in Oracle, like the MD5() function in MySQL. After some searching I found out that there was no direct way to gene... Read more
20 Aug 2016 - less than 1 minute readMySQL punch user creation DDL
#mysqlYou can get the DDL necessary to duplicate an existing user with the following system command: MYSQL_CONN="-uroot -ppassword" mysql ${MYSQL_CONN} --skip-column-names -A -e "SELECT CONCAT('SHOW GRA... Read more
20 Jul 2016 - less than 1 minute readInnoDB table rebuild
#mysqlPROBLEM On a MySQL 5.6 database server, the ibdata1 file includes 5 InnoDB tables in the mysql schema. mysql> select table_name from information_schema.tables -> where table_schema='mys... Read more
20 Jun 2016 - 1 minute readTransfer multiple files simultaneously using SCP
#linuxI have been using the Secure Copy (scp) utility for copying files between my local server and development server. Sometimes I have to copy more than one file. Copying each file can be very annoying... Read more
20 May 2016 - 1 minute readResolve the ORA-01157 Error
#oracleAnother day at the office, I was investigating a performace issue when I encountered the following error: Select count(*) from purchase.table where CREATION_DATE > SYSDATE - 40; Execution Plan... Read more
20 Apr 2016 - less than 1 minute readKill locked sessions
#oracleSometimes, when there’s many database sessions connected and depending on the user activity, locks can occur on a database. While this may only affect a few users, the problem is that with many ses... Read more
20 Mar 2016 - 1 minute readMySQL regexp Replace
#mysqlMySQL provides you with a useful string function called REPLACE that allows you to replace a string in a column of a table by a new string. The REPLACE function is very handy to search and replace ... Read more
20 Feb 2016 - 1 minute readPostgreSQL Survival Guide
#postgresql #databasePostgreSQL has been gaining a lot of popularity these days, so let’s have a look at the basics of administering a PostgreSQL database. We’ll cover the structure exploration, object manipulation and... Read more
20 Jan 2016 - 3 minute readExtract tablespace DDL
#oracleShould you need to perform a large data export and import on different Oracle databases, you’ll need to make sure that the tablespace configuration matches your export and import parameters. Wheth... Read more
20 Dec 2015 - less than 1 minute readFixing the ORA-00600: [ktfbtgex-7] error
#oracleIt was a normal day at the office, when I noticed an ORA-00600 on a production database. Upon investigation, I found the following details in the alert.log file: ORA-00600: internal error code, ar... Read more
20 Nov 2015 - 1 minute read