One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.…
Tag: Featured
1st Run of the Year
I earned a badge on Garmin Connect. #garmin #beatyesterday
New Years Eve Running
I earned a badge on Garmin Connect. #garmin #beatyesterday
Monty Python star Terry Gilliam breaks his silence over his show being cancelled | Daily Mail Online
Comedian Terry Gilliam, 81, has said he never thought 'freedom of recommendation' would be under threat after his show was cancelled by The Old Vic theatre in London. — Read on http://www.dailymail.co.uk/news/article-10306721/Monty-Python-star-Terry-Gilliam-breaks-silence-cancelled.html
How to Improve Your Running – Stop Caring About Running Data and Times
In the last two years, obsessing over the stream of data from my GPS watch had caused me to go too far, too fast. Here’s what I learned when I stopped caring. — Read on http://www.runnersworld.com/training/a37528979/how-to-improve-your-running-stop-caring-about-times-data/
Estimate Defragmentaton Benefits for a Bigfile Tablespace
Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a…
Read More Estimate Defragmentaton Benefits for a Bigfile Tablespace
Postul Nașterii Domnului, timp de înfrânare și sporire duhovnicească
Postul a fost rânduit doar pentru folosul duhovnicesc al omului, spune Sfântul Ioan Gură de Aur. Începând cu 15 noiembrie, Biserica ne cheamă să ne desăvârşim prin post timp de 40 de zile pentru a fi pregătiţi de marea sărbătoare…
Read More Postul Nașterii Domnului, timp de înfrânare și sporire duhovnicească
Column Level Collation Example
The feature was first introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled. I work on an great autonomous TP instance and it is…
Starting Oracle SQL Developer with Custom Parameters
I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which…
Read More Starting Oracle SQL Developer with Custom Parameters
Setup a VirtualBox based Database Lab Environment
Oracle provides a lot of useful Oracle VirtualBox Pre-built Appliances. In this blog post, I will describe the few extra steps I take after download in order to setup my lab environment on my work MacBook Pro. First step is…