Overview: SELECT SAMPLE

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.…

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…

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…

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…

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…

%d bloggers like this: